hi,
How to retrieve data from database to Gridview when i Doubleclick a particular cell using C#.i past my code bellow,plz help me
private void Form3_Load(object sender, EventArgs e)
{
cn = new SqlConnection("data source=server2;database=costing1;user id=sa;password=sa");
da = new SqlDataAdapter("select *from CATABLE001 where 1=2", cn);
ds = new DataSet();
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
da.Fill(ds, "CATABLE001");
dataGridView1.DataSource = ds.Tables[0];
private void dataGridView1_DoubleClick(object sender, EventArgs e)
{
int sno = int.Parse(Interaction.InputBox("Enter ItemCode", "db operations", "", 50, 50));
DataRow dr = ds.Tables["CATABLE001"].Rows.Find(sno);
dataGridView1.DataSource = ds.Tables["CATABLE001"];
}