save two

Question

if i have two items in a grid to save by using two different item id's.how can we possible to save these two at a time?in c# 2 tiersql 2005 example: item itemcode tea 10 coffee 11

Sanjeeb Lenka · Answer

Hi you can try like this protected void btninsert_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(connStr); for (int i = 0; i { GridViewRow row = GridView1.Rows[i]; con.Open(); str = insert into itemtable(itemitemcode) values(' + row.Cells[1].Text + '' + row.Cells[2].Text + '); SqlCommand com=new SqlCommand(strcon); com.ExecuteNonQuery(); con.Close(); } }