Gridview not displaying values from Database

Question

I am trying to display a database table in a DataGrid but the DataGrid isn't displaying. All I have is a textbox and under it I want the DataGrid to display the table. The textbox is displaying but the DataGrid isn't.

<table>
     <tbody>
        <tr>
          <td class="Header">Public Holiday Date</td>
          <td>
             <asp:TextBox runat="server"  ID="txtDate" rel="datepicker" ></asp:TextBox>
          </td>
        </tr>
        <tr>
          <td>
            <asp:DataGrid runat="server" id="dataGridView1"  AutoGenerateColumns="true"></asp:DataGrid>    
          </td>
        </tr>
       </tbody>
     </table>

The code for getting the data from the database:

private DataSet GetBankHolidays()
    {
        DataSet ds = new DataSet();

        string sql = "proc_GetAllCustomers";

        string query = "SELECT BankHol FROM bankholidays";

        DataTable dt = new DataTable();
        using (MySql.Data.MySqlClient.MySqlDataAdapter adapter = new MySql.Data.MySqlClient.MySqlDataAdapter(sql, DataUtils.ConnectionStrings["TAT"]))
        {
            adapter.SelectCommand.CommandType = CommandType.Text;
            adapter.SelectCommand.CommandText = query;
            adapter.Fill(dt);
            ds.Tables.Add(dt);
            dataGridView1.DataSource = dt;
            dataGridView1.DataBind();
        }
        return ds;
    }

And I'm calling this method in the page load:

 protected void Page_Load(object sender, EventArgs e)
    {
if (!Page.IsPostBack)
        {
            GetBankHolidays();
        }

    }

Rahul Singh · Accepted Answer · 2015-07-02 09:03:58Z

1

You need to call the DataBind method:-

dataGridView1.DataBind();

Apart from this I would suggest you to separate out the DAL & UI code.

answered Jul 2, 2015 at 9:03

Rahul Singh

21.8k6 gold badges43 silver badges61 bronze badges

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

2 Comments

user123456789 Over a year ago

that gives the error DataGrid with id 'dataGridView1' could not automatically generate any columns from the selected data source.

amantur Over a year ago

try setting AutoGenerateColumns property to true

Imad · Accepted Answer · 2015-07-02 09:06:23Z

1

write dataGridView1.DataBind(); below dataGridView1.DataSource = dt;

answered Jul 2, 2015 at 9:06

Imad

7,52014 gold badges64 silver badges124 bronze badges

9 Comments

user123456789 Over a year ago

that gives the error DataGrid with id 'dataGridView1' could not automatically generate any columns from the selected data source.

Imad Over a year ago

Set Autogeneratecolumn property of gridview to true in your aspx code

Nagaraj S Over a year ago

@user123456789 are you sure that Datatable contains any records. ?

Nagaraj S Over a year ago

@user123456789 not database i am asking does adapter.Fill(dt); contains records ?

Imad Over a year ago

try to debug and see what values come in dt

|

usmanali · Accepted Answer · 2015-07-02 09:43:46Z

1

Your code lacks {dataGridView1.DataBind();} command.

Use the DataBind() method to bind data from a data source to the GridView control.

edited Jul 2, 2015 at 9:43

usmanali

2,0372 gold badges27 silver badges39 bronze badges

answered Jul 2, 2015 at 9:14

Derpuku Der

14612 bronze badges

Comments

Nagaraj S · Accepted Answer · 2015-07-02 09:38:43Z

0

In your coding you are using stored procedure but you have mentioned command type as text

adapter.SelectCommand.CommandType = CommandType.StoredProcedure;

You need to bind DataSource to the DataGrid

dataGridView1.DataBind();

Final code

using (MySql.Data.MySqlClient.MySqlDataAdapter adapter = new MySql.Data.MySqlClient.MySqlDataAdapter(sql, DataUtils.ConnectionStrings["TAT"]))
        {
            adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
            adapter.SelectCommand.CommandText = query;
            adapter.Fill(dt);
            ds.Tables.Add(dt);
            dataGridView1.DataSource = dt;
            dataGridView1.DataBind();
        }

edited Jul 2, 2015 at 9:38

answered Jul 2, 2015 at 9:33

Nagaraj S

13.5k6 gold badges36 silver badges53 bronze badges

Collectives™ on Stack Overflow

Gridview not displaying values from Database

4 Answers 4

2 Comments

9 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

9 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related