读书人

一个关于sqldatasource更新的小疑点

发布时间: 2012-02-11 09:51:34 作者: rapoo

一个关于sqldatasource更新的小问题
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
TextBox fcardpwd = (TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[1];
TextBox fask = (TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[1];
TextBox fanswer = (TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[1];
TextBox fzt = (TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[1];
TextBox fstartime = (TextBox)GridView1.Rows[e.RowIndex].Cells[7].Controls[1];
TextBox fendtime = (TextBox)GridView1.Rows[e.RowIndex].Cells[8].Controls[1];
string fcardid = this.GridView1.DataKeys[e.RowIndex].ToString();
SqlDataSource1.UpdateCommand = "update fuser set fcardpwd=@fcardpwd,fask=@fask,fanswer=@fanswer,fzt=@fzt,fstartime=@fstartime,fendtime=@fendtime where fcardid=@fcardid ";
SqlDataSource1.UpdateParameters.Add( "fcardpwd ", fcardpwd.Text.Trim());
SqlDataSource1.UpdateParameters.Add( "fask ", fask.Text.Trim());
SqlDataSource1.UpdateParameters.Add( "fanswer ", fanswer.Text.Trim());
SqlDataSource1.UpdateParameters.Add( "fzt ", fzt.Text.Trim());
SqlDataSource1.UpdateParameters.Add( "fstartime ", fstartime.Text.Trim());
SqlDataSource1.UpdateParameters.Add( "fendtime ", fendtime.Text.Trim());
SqlDataSource1.UpdateParameters.Add( "fcardid ", fcardid);
SqlDataSource1.Update();
}
catch {
this.Response.Write( " <script> window.alert( '出现错误,请与管理员联系 ') </script> ");
}
}

[解决办法]
呵呵,那我来接分:D

读书人网 >asp.net

热点推荐