using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ } protected void DataList1_EditCommand(object source,
DataListCommandEventArgs e)
{
DataList1.EditItemIndex = e.Item.ItemIndex;
DataList1.DataBind();
} protected void DataList1_CancelCommand(object source,
DataListCommandEventArgs e)
{
DataList1.EditItemIndex = -1;
DataList1.DataBind();
} protected void DataList1_UpdateCommand(object source,
DataListCommandEventArgs e)
{
String asno =
DataList1.DataKeys[e.Item.ItemIndex].ToString();
String assex =
((TextBox)e.Item.FindControl("textssex")).Text;
String asage =
((TextBox)e.Item.FindControl("textsage")).Text;
String asdept =
((TextBox)e.Item.FindControl("textsdept")).Text; SqlDataSource1.UpdateParameters["ssex"].DefaultValue
= assex;
SqlDataSource1.UpdateParameters["sage"].DefaultValue
= asage;
SqlDataSource1.UpdateParameters["sdept"].DefaultValue
= asdept;
SqlDataSource1.Update(); //运行时提示 用户代码未处理sqlException,,‘ssex’附近有错误 DataList1.EditItemIndex = -1;
DataList1.DataBind();
}
}
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ } protected void DataList1_EditCommand(object source,
DataListCommandEventArgs e)
{
DataList1.EditItemIndex = e.Item.ItemIndex;
DataList1.DataBind();
} protected void DataList1_CancelCommand(object source,
DataListCommandEventArgs e)
{
DataList1.EditItemIndex = -1;
DataList1.DataBind();
} protected void DataList1_UpdateCommand(object source,
DataListCommandEventArgs e)
{
String asno =
DataList1.DataKeys[e.Item.ItemIndex].ToString();
String assex =
((TextBox)e.Item.FindControl("textssex")).Text;
String asage =
((TextBox)e.Item.FindControl("textsage")).Text;
String asdept =
((TextBox)e.Item.FindControl("textsdept")).Text; SqlDataSource1.UpdateParameters["ssex"].DefaultValue
= assex;
SqlDataSource1.UpdateParameters["sage"].DefaultValue
= asage;
SqlDataSource1.UpdateParameters["sdept"].DefaultValue
= asdept;
SqlDataSource1.Update(); //运行时提示 用户代码未处理sqlException,,‘ssex’附近有错误 DataList1.EditItemIndex = -1;
DataList1.DataBind();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货