asp.net gridview doesn't display data

Question

protected void Button1_Click1(object sender, EventArgs e)
{
    SqlConnectionStringBuilder connb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["SCS"].ConnectionString);      
    using (SqlConnection conn = new SqlConnection(connb.ConnectionString))
    {
        SqlCommand cmd = new SqlCommand("Select * from dbo.Users;", conn);
        DataTable tb = new DataTable();

        SqlDataAdapter da = new SqlDataAdapter(cmd);

        da.Fill(tb);
        tb.AcceptChanges();
        GridView1.DataSource = tb;
        GridView1.DataBind();
     }
}

This is my code in C# asp.net application. I want to display SQL table in gridview.

<Columns>
  <asp:BoundField ItemStyle-Width="150px" DataField="name" HeaderText="name" />
  <asp:BoundField ItemStyle-Width="150px" DataField="lastname" HeaderText="lastname" />
  <asp:BoundField ItemStyle-Width="150px" DataField="ID" HeaderText="ID" />
</Columns>

IT shows empty gridview(When I press button1). It doesn't shows any error message. Connection string works, SQL command affects rows, But it still doesn't show any data on gridview!!!

Can anyone help me?

Have you tried debugging and checking that there is actually data in the table when it is being data bound? — GarethD
– GarethD, Commented Dec 31, 2013 at 9:32
Have you tried debugging your actual web page to ensure that button1 is correctly hooked up to the method, and to ensure that there are rows in tb? — GarethD
– GarethD, Commented Dec 31, 2013 at 9:44
See my answer. i hopes it may helps you stackoverflow.com/a/20855275/2218635 — Ramesh Rajendran
– Ramesh Rajendran, Commented Dec 31, 2013 at 9:48

Bridge · Accepted Answer · 2014-12-22 16:26:00Z

1

You could be getting exception in DataBind() - use a try-catch block. This could happen due to a missing column in the DataTable that is being used in a bound field.

 protected void Button1_Click1(object sender, EventArgs e)
 {

   SqlConnectionStringBuilder connb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["SCS"].ConnectionString);
   using (SqlConnection conn = new SqlConnection(connb.ConnectionString))
   {
    try
    {
      SqlCommand cmd = new SqlCommand("Select * from dbo.Users;", conn);
      DataTable tb = new DataTable();

      SqlDataAdapter da = new SqlDataAdapter(cmd);

      da.Fill(tb);
      tb.AcceptChanges();
      GridView1.DataSource = tb;
      GridView1.DataBind();
      GridView1.Rows[0].Cells[0].Text. = "a";
    }
    catch(Exception ex)
    {
         Response.Write(ex.Message);
    }     
   }           
}

edited Dec 22, 2014 at 16:26

Bridge

30.9k10 gold badges64 silver badges85 bronze badges

answered Dec 31, 2013 at 9:21

Adil

148k25 gold badges217 silver badges207 bronze badges

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

8 Comments

Binier Over a year ago

gridview1.rows[0].cells[0].text _ it was extra(I just tried. I wanted to see what would happen). I deleted this but here isn't problem. problem is that datagridview doesn't show any data which is in my sql server.

Adil Over a year ago

I removed that already, check my updated answer. you will get the exception in catch, put a break point in catch block.

Adil Over a year ago

You probably need to put the try catch in side using block, I have updated the answer.

Binier Over a year ago

I tried to use try catch inside using block, but it doesn't work. Gridview doesn't show any data.

Adil Over a year ago

Can you see data in datatable after fill method?

|

ken lacoste · Accepted Answer · 2015-05-26 10:03:54Z

1

DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds);

GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();

edited May 26, 2015 at 10:03

answered May 26, 2015 at 9:31

ken lacoste

8948 silver badges22 bronze badges

Comments

Eduard Malakhov · Accepted Answer · 2018-03-18 10:45:29Z

1

Seems like your query never gets executed

cmd.ExecuteNonQuery ()

This should have happened before this line

SqlDataAdapter da = new SqlDataAdapter(cmd);

edited Mar 18, 2018 at 10:45

Eduard Malakhov

1,1224 gold badges13 silver badges25 bronze badges

answered Mar 18, 2018 at 8:49

Cujoey

1476 bronze badges

Comments

Ramesh Rajendran · Accepted Answer · 2013-12-31 09:56:21Z

0

You should set AutoGenerateColumns="false", if you want to bind specify column.Please check it
And also need to check have you set visible="false" or style="display:none" in your gridview
And check DataField must matched the table column name

edited Dec 31, 2013 at 9:56

answered Dec 31, 2013 at 9:47

Ramesh Rajendran

38.9k49 gold badges159 silver badges241 bronze badges

Comments

diginess · Accepted Answer · 2016-06-08 16:59:30Z

0

I had a problem where I was getting data in the datasource and the GridView wasn't showing up at all. I had AutoGenerateColumns = "true" in the Gridview definition on the page. For some reason, when I set up a breakpoint and looked at the properties of the Gridview in the code behind, it was still set to false. I set it to true in the code behind before setting the Gridview equal to the datasource and doing the databind. That worked.

answered Jun 8, 2016 at 16:59

diginess

1

Comments

kartheekn · Accepted Answer · 2015-10-26 09:35:31Z

-1

       SqlCommand cmd = new SqlCommand("Select * from dbo.Users;", conn);
       SqlDataAdapter da = new SqlDataAdapter(cmd);      
       ds = new DataSet();
       da.Fill(ds, "usersdata");
       GridView1.DataSource = ds.Tables["usersdata"];
       GridView1.DataBind();

answered Oct 26, 2015 at 9:35

kartheekn

13 bronze badges

Collectives™ on Stack Overflow

asp.net gridview doesn't display data

6 Answers 6

8 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

8 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related