how to no data display in gridview from database

nitish rai

Dear Sir

how to no data display in gridview from databasevia store processure.

please dont display in the grid in without value.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bharathi Raja8y ago
http://www.c-sharpcorner.com/UploadFile/d0e913/how-to-display-the-empty-gridview-in-case-of-no-records-in-d/
0
Ajeesh8y ago
You can use EmptyDateTemplate to show a message when gridview datasource is empty
<asp:GridView ID="GridView1" runat="server" >
       <EmptyDataTemplate>
           No results match the specified search criteria.
       EmptyDataTemplate>
   asp:GridView>
0
Amit Gupta8y ago
Hey

You mean that if your database doesn't return any row then don't display the gridview?

If it is like that why don't you check the rows count of the datatable

var rows = datatable.Rows.Count;
gridview.Visible = rows.Count>0;
0