I am loading data from my database file to Datagrid. Doubleclick on a row in datagridview in c#, open new from with 2 button like update and delete. if I select update, which record I selected in datagrid with that one new form should open. I am not getting idea how to do that. Here is my code loading datagrid with a database file
con.Open(); SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM[dbo]. [itemDB]", con); DataTable dt = new DataTable(); sda.Fill(dt); foreach (DataRow item in dt.Rows) { int n = dataGridView1.Rows.Add(); dataGridView1.Rows[n].Cells[0].Value = item["itmcode"].ToString(); dataGridView1.Rows[n].Cells[1].Value = item["brname"].ToString(); dataGridView1.Rows[n].Cells[2].Value = item["itmname"].ToString(); dataGridView1.Rows[n].Cells[3].Value = item["itmunit"].ToString(); dataGridView1.Rows[n].Cells[4].Value = item["itmgr"].ToString(); dataGridView1.Rows[n].Cells[5].Value = item["itmml"].ToString(); dataGridView1.Rows[n].Cells[6].Value = item["itmpc"].ToString(); dataGridView1.Rows[n].Cells[7].Value = item["itmtx"].ToString(); dataGridView1.Rows[n].Cells[8].Value = item["itmbyp"].ToString(); dataGridView1.Rows[n].Cells[9].Value = item["itmdlrmrg"].ToString(); dataGridView1.Rows[n].Cells[10].Value = item["itmrtmrg"].ToString(); dataGridView1.Rows[n].Cells[11].Value = item["itmdlrp"].ToString(); dataGridView1.Rows[n].Cells[12].Value = item["itmmrp"].ToString(); dataGridView1.Rows[n].Cells[13].Value = item["itmusrcode"].ToString(); dataGridView1.Rows[n].Cells[14].Value = item["active"].ToString(); } con.Close();
BindingSource
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)