Add a new Row in a datagridview which is binded to a datatable

[amitj]

I fetch the data datafrom database in to a datatable and bind it to a datagridview.Now I want to edit the data shown in the datagridviewand also want to add new rows in dgv.The editing part is going ok but I m not able to add new rows in dgv.Also I want S.No. column to be autogenerated on new row...the coding is below

if (con.State == ConnectionState.Closed)
{
con.Open();
}
DataColumn Col;

Col = new DataColumn();
Col.DataType = System.Type.GetType("System.String");
Col.ColumnName = "S.No.";
dt_medilist1.Columns.Add(Col);
SqlDataAdapter adp1 = new SqlDataAdapter("Select Drugs,Schedule,Instructions,(DateTo)Till,Route,(Qty)Quantity,Comments from tblTreatment where Patient=111", con);
adp1.Fill(dt_medilist1);
int rows = dt_medilist1.Rows.Count;

for (int i = 0; i < rows; i++)
{
dt_medilist1.Rows[i]["S.No."] = i + 1;
}
dataGridView1.DataSource = dt_medilist1;

[bruce2424]

you can add new row using dataview

http://vb.net-informations.com/dataview/dataview-new-row.htm

bruce.

[LizR]

Did you enable adding records in your datagridview, and if you're manually adding them have you tried adding them to the datasource?

[Jugortha]

It is impossible to add a datagridviewrow to a data bound data grid, if you do you will recieve an exception at run time