How to Bind DataGridView with SqlDataReader

Question

Can anyone help me in this Code Please. I am trying to bind data with datagridview. Query is returning values in sql server. But it's not binding any value in DataGridView....

     private void CheckMembers()
     {
        try
        {
            string query = "Select id, id-no, status From Members Where Head=@Head";

            sqlCommand = new SqlCommand(query, sqlConnection);
            sqlConnection.Open();
            sqlCommand.Parameters.AddWithValue("@Head", "2288885858");
            sqlDataReader = sqlCommand.ExecuteReader();

            if (sqlDataReader.HasRows)
            {
                fmGview.Visible = true;
                DataTable dt = new DataTable();
                dt.Load(sqlDataReader);
                MessageBox.Show(dt.ToString());
                fmGview.DataSource = dt;
            }
        }
        catch (Exception exp)
        {
            MessageBox.Show(exp.ToString(), "Exception in CheckMembers");
        }
        finally
        {
            CheckConnectionStatus();
        }
   }

This should work i think. Are you sure your sql find some data? — Sebi
– Sebi, Commented Nov 7, 2016 at 12:18
i tested your code. it works fine. maybe your fieldname on grid has a typo or something. — Badiparmagi
– Badiparmagi, Commented Nov 7, 2016 at 12:24
if you double-checked and dt is not empty, please also post yout UI code. DataGridView doesn't belong to wpf — ASh
– ASh, Commented Nov 7, 2016 at 13:41

15ee8f99-57ff-4f92-890c-b56153 · Accepted Answer · 2021-03-25 13:25:13Z

5

Set DataPropertyName for each column in the Columns designer. You do this by putting the mouse pointer over the right hand cell in the DataPropertyName row, where it says (none), and clicking the left mouse button. Select the text that says "(none)", and type the database field name that you want to be displayed in that DataGridView column.

edited Mar 25, 2021 at 13:25

answered Nov 7, 2016 at 17:08

15ee8f99-57ff-4f92-890c-b56153

37.1k7 gold badges68 silver badges123 bronze badges

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

7 Comments

15ee8f99-57ff-4f92-890c-b56153 Over a year ago

Click the mouse in the box and type the name of the field. In the one that you want to be id, type "id".

Mistr Mowgli Over a year ago

It start inserting blank rows only

15ee8f99-57ff-4f92-890c-b56153 Over a year ago

@MistrMowgli What did you type in that box?

15ee8f99-57ff-4f92-890c-b56153 Over a year ago

I don't think so. This code shows how to send DataTable changes back to the SQL database.

Mistr Mowgli Over a year ago

Thanks for helping... Really Appreciated

|

Collectives™ on Stack Overflow

How to Bind DataGridView with SqlDataReader

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related