功能:只是修改特定一条记录。(无调试错误)
错误:修改了所有记录的数据。
private void DataGrid2_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string key=Convert.ToString(DataGrid2.DataKeys[e.Item.ItemIndex]);
SqlCommandBuilder cb=new SqlCommandBuilder(sqlDataAdapter1);
sqlDataAdapter1.Fill(dataSet11,"Accounts_Users");
DataTable dt=dataSet11.Tables["Accounts_Users"];
DataRow[] rw=dt.Select("UserID='"+key+"'");
DataRow editRow=rw[0];

TextBox EmailAddresstb=(TextBox)e.Item.Cells[4].Controls[0];
TextBox FirstNametb=(TextBox)e.Item.Cells[5].Controls[0];
TextBox LastNametb=(TextBox)e.Item.Cells[6].Controls[0];
for(int i = 0; i < rw.Length; i ++)
{

rw[i]["EmailAddress"]=EmailAddresstb.Text;
rw[i]["FirstName"]=FirstNametb.Text;
rw[i]["LastName"]=LastNametb.Text;
Response.Write(">>>");//只显示一次,说明只有一次循环


}
sqlDataAdapter1.Update(dataSet11,"Accounts_Users");
DataGrid2.EditItemIndex=-1;
sqlDataAdapter1.Fill(dataSet11);
DataGrid2.DataSource=dataSet11.Tables["Accounts_Users"].DefaultView;
DataGrid2.DataKeyField="UserID";
DataGrid2.DataBind();
}