C# - Datagridview cannot bind data from datatable

Question

I have datagridview binding data from datatable. When I checked the number of columns of datatable, it returned 10. However, datagridview got an error when showing more than 8 columns. The error is Index was out of range. Must be non-negative and less than the size of the collection .Below is my code and also an error I got. Please help me!

public void SearchPatient(string query)
    {
        MySqlConnection MysqlConnection = new MySqlConnection(Properties.Settings.Default.connectionString);
        MySqlCommand MysqlCmd = new MySqlCommand(query, MysqlConnection);
        MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
        MyAdapter.SelectCommand = MysqlCmd;
        DataTable dTable = new DataTable();
        MyAdapter.Fill(dTable);
        rows = dTable.Rows.Count;
        MessageBox.Show(rows + "  " + dTable.Columns.Count); // It showed 15 and 10
        dataGridView1.DataSource = dTable;
        dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
        dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font(dataGridView1.ColumnHeadersDefaultCellStyle.Font, FontStyle.Bold);
        dataGridView1.Columns[0].HeaderText = "ID";
        dataGridView1.Columns[1].HeaderText = fullname;
        dataGridView1.Columns[2].HeaderText = birthday;
        dataGridView1.Columns[2].DefaultCellStyle.Format = "dd/MM/yyyy";
        dataGridView1.Columns[3].HeaderText = gender;
        dataGridView1.Columns[4].HeaderText = address;
        dataGridView1.Columns[5].HeaderText = phonenumber;
        dataGridView1.Columns[6].HeaderText = cmnd;
        dataGridView1.Columns[7].HeaderText = note;
       dataGridView1.Columns[8].HeaderText = "ID benh nhan"; // Error: Additional information: Index was out of range. Must be non-negative and less than the size of the collection.

    }

This is my database:

And my query is: SELECT * FROM patientdatabase ORDER BY ID DESC LIMIT 0,15

What is the count of dataGridView1.Columns after you set it's data source? Check the Data Grid View properties in Designer View and see if columns are defined? — Jawwad Alam
– Jawwad Alam, Commented Mar 5, 2018 at 3:50

Jawwad Alam · Accepted Answer · 2018-03-05 04:07:51Z

1

It looks like columns are added in the designer and your DataGridView's AutoGenerateColumns is set to false. As your columns count doesn't match your data source, therefore you are getting this error.

To fix this, either

Add columns in the designer to match the Data source
or, set dataGridView1.AutoGenerateColumns to True

See reference here: https://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.autogeneratecolumns(v=vs.110).aspx

answered Mar 5, 2018 at 4:07

Jawwad Alam

3224 silver badges9 bronze badges

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

1 Comment

Tin Chip Over a year ago

thanks for your help. I just set dataGridView1.AutoGenerateColumns = true and It works.

Collectives™ on Stack Overflow

C# - Datagridview cannot bind data from datatable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related