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, Nov 07 '16 at 12:18
i tested your code. it works fine. maybe your fieldname on grid has a typo or something. — Badiparmagi, Nov 07 '16 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, Nov 07 '16 at 13:41
@ASh, I have a datagridview with 4 columns. But i am trying to bind only one column. Is it the problem ? — Mistr Mowgli, Nov 07 '16 at 14:16
@ASh, there is no specific code. Only on runtime i am trying to bind datagridview — Mistr Mowgli, Nov 07 '16 at 14:25
How do you know you have connected to the db? Try strong typed value for @Head and see if you get anything back — Daniel, Nov 07 '16 at 14:45
@Daniel, i have 4 columns that need to show. One is Serial Number, Id, Permission Status and last Column is for Link {Delete} — Mistr Mowgli, Nov 07 '16 at 14:52
I now but first eliminate the stupidest solutions and then the rest of them. Where is the column called Head ? — Daniel, Nov 07 '16 at 14:53
@MistrMowgli How many rows are in `dt`? Please change your MessageBox call so it look exactly like this: `MessageBox.Show(dt.Rows.Count.ToString() + " is the count of rows in dt");` — 15ee8f99-57ff-4f92-890c-b56153, Nov 07 '16 at 14:55
@MistrMowgli Please go into the VS form designer for your form, click on `fmGview` in the form designer, and go to the "Properties" pane. Select the "Columns" row in "Properties", and click on the "..." button by where it says "**(Collection)**". Then take a screenshot using `ALT+PrtScr` and add the screenshot to your question. — 15ee8f99-57ff-4f92-890c-b56153, Nov 07 '16 at 15:09

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

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 '21 at 13:25

answered Nov 07 '16 at 17:08

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

36,786
7
62
114

Click the mouse in the box and type the name of the field. In the one that you want to be `id`, type "id". – 15ee8f99-57ff-4f92-890c-b56153 Nov 07 '16 at 17:11
It start inserting blank rows only – Mistr Mowgli Nov 07 '16 at 17:18
@MistrMowgli What did you type in that box? – 15ee8f99-57ff-4f92-890c-b56153 Nov 07 '16 at 17:19
...Yes Man u did it... i got it :) – Mistr Mowgli Nov 07 '16 at 17:21
Is it directly bind with database now ? I mean if i will update anything in datagridview it will be automatically update in database or should i safe again ? – Mistr Mowgli Nov 07 '16 at 17:25
1

I don't think so. [This code shows how to send `DataTable` changes back to the SQL database](http://stackoverflow.com/a/15293977/424129). – 15ee8f99-57ff-4f92-890c-b56153 Nov 07 '16 at 17:28
1

Thanks for helping... Really Appreciated – Mistr Mowgli Nov 07 '16 at 17:29

How to Bind DataGridView with SqlDataReader

1 Answers1

Linked