I want to add Rows in DataGridView Dynamicaly,,, I have written following code...



SqlDataAdapter da = new SqlDataAdapter("select * from auth",cs);

SqlCommandBuilder cmb = new SqlCommandBuilder(da);

DataTable dt = new DataTable();

da.Fill(dt);

int found = dt.Rows.Count;

DataRow dr;

for (int i = 0; i <found; i++)

{

dr = dt.Rows[i];

dataGridView1.Rows.Add(dr);

}
_____________________________________

But this says that

"No row can be added to a DataGridView control that does not have columns. Columns must be added first."


Howto correct this?

---

NIIT HOUSE GKP INDIA Please mark the replies as answers if they help and unmark if they don't.

Hi Nitin Chaudhary,

As JohnGrove suggested, using databinding is quite easy in this situation. If you don't want to use that. You can first add column to DataGridView using DataGridView.Columns.Add() method. Then put a loop to through all the rows in DataTable and get data, add them to dataGridView using DataGridView.Rows.Add() method.

Look at the following sample
http://msdn.microsoft.com/en-us/library/zf3zx9fy.aspx
Pay attention to the "PopulateDataGridView" method code in the sample. That can meet your need.

Please tell me if you have anything unclear.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

You should clone the structure of your populated DataTable and bind it to the DataGridView. Then you can add the items.

SqlDataAdapter da = new SqlDataAdapter("select * from auth",cs);
SqlCommandBuilder cmb = new SqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
DataTable structire = dt.Clone();
dataGridView1.DataSource = structure;

//The structure is only the columns. Now you can safely add the rows

---

John Grove - TFD Group, Senior Software Engineer, EI Division, http://www.tfdg.com

You should clone the structure of your populated DataTable and bind it to the DataGridView. Then you can add the items.

SqlDataAdapter da = new SqlDataAdapter("select * from auth",cs);
SqlCommandBuilder cmb = new SqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
DataTable structire = dt.Clone();
dataGridView1.DataSource = structure;

//The structure is only the columns. Now you can safely add the rows

---

John Grove - TFD Group, Senior Software Engineer, EI Division, http://www.tfdg.com

Why not just bind the DataTable?

---

John Grove - TFD Group, Senior Software Engineer, EI Division, http://www.tfdg.com

Hi Nitin Chaudhary,

As JohnGrove suggested, using databinding is quite easy in this situation. If you don't want to use that. You can first add column to DataGridView using DataGridView.Columns.Add() method. Then put a loop to through all the rows in DataTable and get data, add them to dataGridView using DataGridView.Rows.Add() method.

Look at the following sample
http://msdn.microsoft.com/en-us/library/zf3zx9fy.aspx
Pay attention to the "PopulateDataGridView" method code in the sample. That can meet your need.

Please tell me if you have anything unclear.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.