DataSet bulk update problem
-
Hi, I am developing a web appication using asp.net with c#. I am updating Dataset using datgrid EditItemTemplate and storing in cache. finally i want to update my table using SqlAdaptor Update mathod but i am gatting error.Please help me.. This is my Dataset Update mathod: public void grdEmployee_Update(Object o,DataGridCommandEventArgs e) { int id = (int)grdEmployee.DataKeys[e.Item.ItemIndex]; TextBox txtName,txtDesignation,txtSex,txtAge,txtSalary; txtName =(TextBox)e.Item.Cells[0].Controls[0]; txtDesignation =(TextBox)e.Item.Cells[1].Controls[0]; txtSex =(TextBox)e.Item.Cells[2].Controls[0]; txtAge =(TextBox)e.Item.Cells[3].Controls[0]; txtSalary =(TextBox)e.Item.Cells[4].Controls[0]; if (Cache["EMPCACHE"]!=null) { DataSet dsUpdate= (DataSet)Cache["EMPCACHE"]; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["NAME"]=txtName.Text; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["DESIGNATION"]=txtDesignation.Text; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["SEX"]=txtSex.Text; dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["AGE"]=Convert.ToInt32(txtAge.Text); dsUpdate.Tables[0].Rows[e.Item.ItemIndex]["SALARY"]=Convert.ToSingle(txtSalary.Text); dsUpdate.AcceptChanges(); Cache["EMPCACHE"]=dsUpdate; grdEmployee.EditItemIndex = -1 ; grdEmployee.DataSource = dsUpdate; grdEmployee.DataBind(); }} Finally i am going to update on Database using this code private void btnDatabaseUpdate_Click(object sender, System.EventArgs e) { try { string strConnection= System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString"); SqlConnection con = new SqlConnection(); con.ConnectionString = strConnection; SqlDataAdapter sda = new SqlDataAdapter("select ID,NAME,DESIGNATION,SEX,AGE,SALARY from EMPLOYEEDETAILS",con); SqlCommandBuilder scb = new SqlCommandBuilder(sda); sda.Fill(dsObj,"EMPLOYEEDETAILS"); DataSet dsUpdate = (DataSet)Cache["EMPCACHE"]; dsObj = dsUpdate.Copy(); int success=sda.Update(dsObj,"EMPLOYEEDETAILS"); dsObj.AcceptChanges(); grdEmployee.DataSource = dsObj; grdEmployee.DataBind(); } catch (Exception ex) { Response.Write(" " + ex.Message.ToString()); } } I am gatting this error: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. waiting for promp reply