SqlCommand cmd = new SqlCommand("update Test1 set email='ramsinghmscit@gmail.com' where userid=3407 ");
SqlDataAdapter da = new SqlDataAdapter(cmd);
CountryBPPersistence objPersistence = new CountryBPPersistence();
CountryBPEntity objEntity = new CountryBPEntity();
DataSet objDt = new DataSet();
objEntity.UserName = Key;
objDt = objPersistence.Select_CountryBPinDataset(objEntity);
DataRow drCurrent;
drCurrent = objDt.Tables[0].Rows[3];
DataRow drCurrent1;
drCurrent1 = objDt.Tables[0].Rows[5];
drCurrent.BeginEdit();
drCurrent["Email"] = "Jennifer.K.Josephson@Diageo.com";
drCurrent.EndEdit();
drCurrent1.BeginEdit();
drCurrent1["Email"] = "ram.s@jsimple.com";
drCurrent1.EndEdit();
DataRow drCurrent2 = objDt.Tables[0].NewRow();
DataColumn dc = objDt.Tables[0].Columns[0];
drCurrent2[0] = 2002;
drCurrent2[2] = "ram.s@jsimple.com";
objDt.Tables[0].Rows.Add(drCurrent2);
// dc.
//drCurrent.Delete();
//drCurrent1.Delete();
// SqlCommandBuilder obj = new SqlCommandBuilder(da);
//da.Update(objDt, objDt.Tables[0].ToString());
//DataSet ds1 = objDt.GetChanges(DataRowState.Modified);
DataSet ds1 = objDt.GetChanges(DataRowState.Added);
// DataSet ds1 = objDt.GetChanges();
// da.Fill(ds1);
//da.Update(objDt.Tables[0]);
GridView2.DataSource = ds1;
GridView2.DataBind();
No comments:
Post a Comment