GridView in ASP.NET

Bineesh Viswanath

Sir, I am working with asp.net Grid.

My issue is that Grid is not displaying on page load in case of no data in sql Table.

But Grid is showing on page load when i inserted data into table.

can display Grid without data in it?, if can, please send me the code.

Here the code I do:-

public void GridFill()
        {
            DA = new SqlDataAdapter("select * from tbl_Employee", sqlCon);
            dtbl = new DataTable();
            DA.Fill(dtbl);
            cmdbuilder = new SqlCommandBuilder(DA);
            gvEmployee.DataSource = dtbl;
            gvEmployee.DataBind();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                GridFill();
            }
        }

Please help me in this topic.

6 Replies

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

Iftikar Hussain13y ago
Accepted answer
Hi,
Set the below property for the gridview

ShowHeaderWhenEmpty="True" EmptyDataText="No records Found">

Regards,
Iftikar
0
Iftikar Hussain13y ago
You can't do directly. You have to write some code for these. Please refer the below link

http://geekswithblogs.net/dotNETvinz/archive/2009/03/11/tiptrick-show-header-and-footer-of-gridview-when-no-data.aspx

Regards,
Iftikar
0
Prasenjit Dey13y ago
Hi,

At first use my code, what I have given to you, you will get your answer and prob will be solve

if not satisfied, then check that url:

http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html

happy coding
0
Bineesh Viswanath13y ago
Sir, I got what I needed, but still one more task is to be done.

My data insertion into Grid is through footer textbox and buttons. These lays in footerRow.

So I want to show footer row also when Grid is empty.

Is there any code?, please send.
0
Bineesh Viswanath13y ago
Thank you all for helping me.
0
Prasenjit Dey13y ago
Hi, Use this code :

protected void BindGridviewData()
{
SqlConnection con = new SqlConnection("Data Source=MYSystem;Initial Catalog=MySamplesDB;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("select UserName,FirstName,LastName,Location from UserDetails", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if(ds.Tables[0].Rows.Count==0)
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gvdata.DataSource = ds;
gvdata.DataBind();
int columncount = gvdata.Rows[0].Cells.Count;
gvdata.Rows[0].Cells.Clear();
gvdata.Rows[0].Cells.Add(new TableCell());
gvdata.Rows[0].Cells[0].ColumnSpan = columncount;
gvdata.Rows[0].Cells[0].Text = "No Records Found";
}
else
{
gvdata.DataSource = ds;
gvdata.DataBind();
}
con.Close();
}

Carefully copy and replace your variables of this part

if(ds.Tables[0].Rows.Count==0)
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
gvdata.DataSource = ds;
gvdata.DataBind();
int columncount = gvdata.Rows[0].Cells.Count;
gvdata.Rows[0].Cells.Clear();
gvdata.Rows[0].Cells.Add(new TableCell());
gvdata.Rows[0].Cells[0].ColumnSpan = columncount;
gvdata.Rows[0].Cells[0].Text = "No Records Found";
}
else
{
gvdata.DataSource = ds;
gvdata.DataBind();
}
0