How to show gridview when table data or data source is empty.

potnuru ram prasad

15y8.7k.NET

Hello Experts,
I am working on Gridview , which has operations like insert , update , delete and edit operation, every operation is working fine when table data exist , and binding properly, when there is no data in the table, its not showing any thing except, no records found. but i want to insert new row through gridview for empty data source, please suggest me regarding this. if any body having sample code, please send me.

Thanks
Ram.

4 Replies

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

Abhimanyu K Vatsa15y ago
you need to place separate header or footer for to insert new record for always even when no any record there. look at the code below:-

AutoGenerateColumns="False"
DataKeyNames="ID"
DataSourceID="SqlDataSource1"
OnRowDeleted="GridView1_RowDeleted"
OnRowUpdated="GridView1_RowUpdated"
ShowFooter="true"
OnRowCommand="GridView1_RowCommand">

ShowEditButton="True" />

Text='<%#Eval("ID") %>'>

Text="Insert" CommandName="Add" />



SortExpression="FirstName">

Text='<%#Eval("FirstName") %>'>

Text='<%#Bind("FirstName") %>'>



SortExpression="LastName">

Text='<%#Eval("LastName") %>'>

Text='<%#Bind("LastName") %>'>



SortExpression="Department">

Text='<%#Eval("Department") %>'>

Text='<%#Bind("Department") %>'>



SortExpression="Location">

Text='<%#Eval("Location") %>'>

Text='<%#Bind("Location") %>'>

More here

hope this helps
Ish Bandhu15y ago
//Show header and footer if no data found
DataTable dt=new DataTable();

dt.Rows.Add(dt.NewRow);
gridview.DataSource=dt;
gridview.DataBind();

int count=gridview.columns.count;

gridview.Rows[0].Clear();

gridview.Rows[0].Cells.Add(new TableCell());
gridview.Rows[0].Cells[0].ColumnSpan = count;
gridview.Rows[0].Cells[0].Text="No Data Found."
Suthish Nair15y ago
If(gv.Rows.Count == 0)
{
   DataTable dt = new DataTable();
   dt.Columns.Add("Name", typeof(string));
   dt.Rows.Add("Test");

gv.DataSource = dt;
gv.DataBind();
dt = null;
}
Ish Bandhu15y ago
You can show only header of the grid but u need to create seprate headre