How to retrieve data from database to Gridview when i Doubleclick a particular cell using C#?

hi , this is the code for it. i hope this will help for you . private void DataGridView1_DoubleClick(object sender, EventArgs e) { int li_contract_no = 0; String ls_gv_value = (DataGridView1.CurrentRow.Cells["col_name"].Value.ToString()); //int li_currentRow = DataGridView1.CurrentRow; if (ls_gv_value != "") { li_contract_no = Convert.ToInt32(ls_gv_value); } //Get the serial no from the clicked row on the gridview //li_serial_no = if (li_contract_no > 0) { textbox1.Text = DataGridView1.CurrentRow.Cells["col_name"].Value.ToString(); textbox2.Text = DataGridView1.CurrentRow.Cells["col_name"].Value.ToString(); textbox3.Text = DataGridView1.CurrentRow.Cells["col_name"].Value.ToString(); textbox3.Text = DataGridView1.CurrentRow.Cells["col_name"].Value.ToString(); textbox4.Text = DataGridView1.CurrentRow.Cells["col_name"].Value.ToString(); textbox5.Text = DataGridView1.CurrentRow.Cells["col_name"].Value.ToString(); } }