check for if a gridview is empty

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is a good way to check for a gridview or a datasource not having any rows?
If my gridview does not have any rows i want to display a message saying the
recordset is empty.

I'm doing it now by setting the message visible = true on page load
and set it to false on

if (e.Row.RowType == DataControlRowType.DataRow)
this.Label1.Visible = false;

Meaning it get s set to false on each row. I'd like a better way.

Thanks
KES
--
(i''ll be asking a lot of these, but I find C# totally way cooler than vb
and there''s no go''n back!!!)
thanks (as always)

kes
 
What is a good way to check for a gridview or a datasource not having any rows?
If my gridview does not have any rows i want to display a message saying the
recordset is empty.

I'm doing it now by setting the message visible = true on page load
and set it to false on

if (e.Row.RowType == DataControlRowType.DataRow)
this.Label1.Visible = false;

Meaning it get s set to false on each row. I'd like a better way.

Thanks
KES
--
Click to expand...

Do you know that there is the EmptyDataText Property that can be used
to show such message?
http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.emptydatatext.aspx
 
No i did not that is why i asked the question. Thank you for this answer it
is very much appreciated.


--
(i''ll be asking a lot of these, but I find C# totally way cooler than vb
and there''s no go''n back!!!)
thanks (as always)

kes
 
No i did not that is why i asked the question. Thank you for this answer it
is very much appreciated.
Click to expand...

okay, and if you still want to use code-behind you can use Rows.Count
property

....
GridView1.DataBind();
if (GridView1.Rows.Count == 0) {
Label1.Text = "No records found";
Label1.Visible = true;
}
 
i was adding header rows on row data bound or row created and this was always
throwing the count off.

I did not see that property for empty text. Again This was an obvious, big
still a big help!
--
(i''ll be asking a lot of these, but I find C# totally way cooler than vb
and there''s no go''n back!!!)
thanks (as always)

kes
 
Back
Top