以前我用recordset.add，现在用什么？谢谢·····

Question

DataAdapter.Update();
SqlCommand.ExecuteNonQuery();
SqlCommand.ExecuteReader();
.....

Answer 1

TextBox per=(TextBox)e.Item.FindControl("TextBox3");
string newpe=per.Text;

SqlConnection conn =new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
string comm="SELECT PersonID,PersonEmail FROM Person";
SqlDataAdapter ada=new SqlDataAdapter(comm,conn);
SqlCommandBuilder sc=new SqlCommandBuilder(ada);
DataSet ds=new DataSet();

ada.Fill(ds,"Person");

DataTable titlesTable=ds.Tables["Person"];
int pid=(int)authorsGrid.DataKeys[e.Item.ItemIndex];
DataRow[] rows=titlesTable.Select("personID='" + pid + "'");
DataRow editrow = rows[0];
editrow.BeginEdit();
editrow["PersonEmail"]=newpe;

editrow.EndEdit();
ada.Update(ds,"Person");
editrow.AcceptChanges();


conn.Close();
authorsGrid.EditItemIndex=-1;