菜鸟问题~谢谢大家

jerrykan 2004-10-27 11:04:16

不知道为什么不能更新数据

<% @ Page Language="C#" Debug="true" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<Script Language="C#" Runat="Server">
OleDbConnection MyConn;
public void Page_Load(Object src,EventArgs e)
{
//连接语句
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"/db1.mdb;";
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();

if(!Page.IsPostBack)
{
ListBind();
}
}

ICollection CreateSource()
{
string strSel = "select * from Score";
DataSet ds = new DataSet();

OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"Score");

return ds.Tables["Score"].DefaultView;
}
public void ListBind()
{
score.DataSource = CreateSource();
score.DataBind();
}
public void DataList_EditCommand(Object sender,DataListCommandEventArgs e)
{
score.EditItemIndex = (int)e.Item.ItemIndex;
ListBind();
}
public void DataList_CancelCommand(Object sender,DataListCommandEventArgs e)
{
score.EditItemIndex = -1;
ListBind();
}
public void DataList_UpdateCommand(Object sender,DataListCommandEventArgs e)
{
string strItemmc = ((Label)e.Item.FindControl("lblItemmc")).Text;
string strItemfzr = ((TextBox)e.Item.FindControl("tdItemfzr")).Text;
string strItemlcfs = ((TextBox)e.Item.FindControl("tdItemlcfs")).Text;
string strItemsj = ((TextBox)e.Item.FindControl("tdItemsj")).Text;
string strItemjssj = ((TextBox)e.Item.FindControl("tdtbItemjssj")).Text;
string strItembak = ((TextBox)e.Item.FindControl("tdItembak")).Text;
//更新数据库中的数据
string strUpdate = "Update Score Set Itemfzr='"+strItemfzr+"',Itemlcfs='"+strItemlcfs+"',Itemsj='"+strItemsj+"',Itemjssj='"+strItemjssj+"',Itembak='"+strItembak+"' Where Itemmc='"+strItemmc+"'";
OleDbCommand MyComm = new OleDbCommand(strUpdate,MyConn);
MyComm.ExecuteNonQuery();

score.EditItemIndex = -1;
ListBind();
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form runat="server">
<asp:DataList id="score" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="Gainsboro"
EditItemStyle-BackColor="yellow"
RepeatLayout="Table"
OnEditCommand="DataList_EditCommand"
OnUpdateCommand="DataList_UpdateCommand"
OnCancelCommand="DataList_CancelCommand"
>
<HeaderTemplate>
项目列表
</HeaderTemplate>
<ItemTemplate>
项目名称：<%# DataBinder.Eval(Container.DataItem,"Itemmc") %>
<asp:LinkButton id="btnSelect" Text="编辑" CommandName="edit" runat="server" />
</ItemTemplate>
<EditItemTemplate>
项目名称：<asp:Label id="lblItemmc" Text='<%# DataBinder.Eval(Container.DataItem,"Itemmc") %>' runat="server" /><br>
项目负责人：<asp:TextBox id="tbItemfzr" Text='<%# DataBinder.Eval(Container.DataItem,"Itemfzr") %>' runat="server" /><br>
项目委托方联系方式：<asp:TextBox id="tbItemlcfs" Text='<%# DataBinder.Eval(Container.DataItem,"Itemlcfs") %>' runat="server" /><br>
项目时间：<asp:TextBox id="tbItemsj" Text='<%# DataBinder.Eval(Container.DataItem,"Itemsj") %>' runat="server" /><br>
项目时间：<asp:TextBox id="tbItemjssj" Text='<%# DataBinder.Eval(Container.DataItem,"Itemjssj") %>' runat="server" /><br>
项目备注: <asp:TextBox id="tbItembak" Text='<%# DataBinder.Eval(Container.DataItem,"Itembak") %>' runat="server" /><br>
<asp:LinkButton id="lbnUpdate" Text="更新" CommandName="update" runat="server" />
<asp:LinkButton id="lbnCancel" Text="取消" CommandName="cancel" runat="server" />
</EditItemTemplate>
</asp:DataList>

</form>
</body>
</html>

显示这一句有错误

...全文

194 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

penning 2004-10-27

打赏
举报

string strItemfzr = ((TextBox)e.Item.FindControl("tdItemfzr")).Text;
－－》
string strItemfzr = ((TextBox)e.Item.FindControl("tbItemfzr")).Text;

xiaohutushen 2004-10-27

打赏
举报

cuike519 2004-10-27

打赏
举报

string strItemfzr = ((TextBox)e.Item.FindControl("tdItemfzr")).Text;
这一句本身就有问题，如果程序按照你预计的执行那么没有问题，但是通常不是这样的。
你没有判断tdItemfzr这个控件是否存在，就直接转换后.Text。这样是不对的，以下的做法比较安全：
Control ctl = e.Item.FindControl("tdItemfzr");
if(ctl!=null && ctl is TextBox){
strItemfzr = ((TextBox)e.Item.FindControl("tdItemfzr")).Text;
}
else{
strItemfzr = "";

luaiping 2004-10-27