Remove One Row from DataGridView [modified]

[M Riaz Bashir]

Hi, I have 5 rows in my datagridview1. but how to remove any particular row? when I use => "dataGridview1.Rows.RemoveAt(4)" then error comes "Uncommited new row cannot be deleted". :( Thank you in advance -- modified at 3:22 Wednesday 19th September, 2007

[sri_ashutosh]

hello dear, try it string dgvstr=""; SqlDataAdapter da = new SqlDataAdapter("select (enter all columan_name in table) from table_name", con); dgvstr = da.SelectCommand.CommandText.Replace(",enter remove columan_name", ""); DataSet ds = new DataSet(); da.Fill(ds, "table_name"); datagridview.DataSource = ds.Tables[0]; datagridview.Columns[enter remove column_index(ex-0)].Visible = false; datagridview.Rows[0].Selected = true;

[rohitsrivastava]

datagridview1.currentrow.cell(0).value this will work and give the connection