ASP.NET [How to check if SqlDataSource1 is empty]

Question

I make SqlDataSource1.DataBind(); with some parameters on button click,

then I'm working with a Grid onDataBound();

but if my SqlDataSource1 returns empty data I've got an error even if I'm trying to check if (GridView2.HeaderRow.Cells.Count != 0) so I guess I need to check it on SqlDataSource1 someway.

Question : How ?

Thank you.

Carl Rippon · Accepted Answer · 2010-01-25 06:52:59Z

1

GridView2.HeaderRow is null when when the data source is null so you could try checking if GridView2.HeaderRow = null

answered Jan 25, 2010 at 6:52

Carl Rippon

4,6939 gold badges54 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andy West · Accepted Answer · 2010-01-25 06:55:03Z

0

I would check GridView2.Rows.Count instead. Maybe there are no HeaderRow cells when the data source is empty.

answered Jan 25, 2010 at 6:55

Andy West

12.5k4 gold badges37 silver badges52 bronze badges

2 Comments

cnd Over a year ago

I'm not sure I have access to rows - count when datasource is empty, but previous answer works for sure.

Andy West Over a year ago

Row count should be zero after DataBind() on the GridView, but either way, it's good that you have a solution that works.

Collectives™ on Stack Overflow

ASP.NET [How to check if SqlDataSource1 is empty]

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related