求救！100分，在线等！

[ZPRC]

private void Account_Grid_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
TextBox TBBankName;
TextBox TBSubBankName;
TextBox TBAccount;
TextBox TBRealName;
TBBankName=(TextBox)(e.Item.Cells[0].Controls[0]);
TBSubBankName=(TextBox)(e.Item.Cells[1].Controls[0]);
TBAccount=(TextBox)(e.Item.Cells[2].Controls[0]);
TBRealName=(TextBox)(e.Item.Cells[3].Controls[0]);
string sqlStr="Update BankAccount set RealName='"+TBRealName.Text+
"',BankName='"+TBBankName.Text+"',SubBankName='"+TBSubBankName.Text+
"',BankAccount='"+TBAccount.Text+
"' where BankAccount="+Account_Grid.DataKeys[e.Item.ItemIndex];
UserTools.ExecuteSQL(sqlStr);
Account_Grid.EditItemIndex = -1;
BindGrid();
}
修改前TBBankName的值是“中行”
把它改为“农行”
运行UPDATE之后结果 TBBankName=(TextBox)(e.Item.Cells[0].Controls[0]);取到的值还是“中行”，郁闷！

[jxzhang615]

帮顶！

[Eddie005]

贴出关于DataGrid绑定的代码；有没有!IsPostBack
Page_Load()
{
if(!IsPostBack)
{
.....
Account_Grid.DataSource="";
Account_Grid.DataBind();
....
}
}

[CSTerry]

数据库里面的值变了么？
运行的时候在string sqlStr那里设个断点，看看值究竟是什么

[lih163]

private void dg1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{

try
{
DataSet ds1 = new DataSet();
ds1.ReadXml(Server.MapPath("/chzn/")+"data.xml");
DataRow dw= ds1.Tables[0].Rows[ Convert.ToInt32(dg1.Items[e.Item.ItemIndex].Cells[4].Text) ];
string provinceid = dw[1].ToString();
string id = dg1.DataKeys[e.Item.ItemIndex].ToString();

//Response.Write(id+provinceid+"<br>" );

XmlElement felemp = findElementByAttribute(xdoc ,"province" ,"id" ,provinceid);

if(felemp == null)
{
Response.Write("没有找到");
return;
}
//Response.Write(felemp.GetAttribute("name"));
XmlElement felem = (XmlElement) felemp.SelectSingleNode("person[@id='"+id+"']");
XmlElement nelem = xdoc.CreateElement("person");
addAttribute(xdoc ,nelem ,"id" ,felem.GetAttribute("id"));
XmlNodeList nlist = felem.ChildNodes;
int i = 0;
foreach ( XmlNode node in nlist)
{
if(node is XmlElement)
{
XmlElement tem = (XmlElement) node;
addTextElement(xdoc ,nelem ,tem.Name,((TextBox)e.Item.Cells[i++].Controls[0]).Text);
//Response.Write(tem.Name);
//Response.Write(tem.InnerText);
//当选择更新时，datagrid所选择的列一清空
//Response.Write(e.Item.Cells[i-1].Text);//此行不会输出任何数据，为空
//Response.Write(((TextBox)e.Item.Cells[i-1].Controls[0]).Text);//可以输出
}
}
felem.ParentNode.ReplaceChild(nelem ,felem);
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
dg1.EditItemIndex = -1;
saveXml(xdoc ,"/chzn/" ,"data.xml");
BindData();
}
}

[liulxmooo]

up