在我点击编辑时,修改完数据时点确定后不能更改数据,我把代码贴出来了,请大家帮帮忙吧,看哪有问题啊?

<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 32px; POSITION: absolute; TOP: 104px"
HeaderStyle-BackColor="#BCBCBC" Width="100%" AllowPaging="True" PageSize="15" PagerStyle-Visible="false"
OnEditCommand="datagrid1_edit" OnCancelCommand="datagrid1_cancel" OnUpdateCommand="datagrid1_update"
OnDeleteCommand="datagrid1_delete" DataKeyField="id" runat="server" BackColor="WhiteSmoke"
BorderColor="#C0C0FF" ForeColor="Transparent">
<HeaderStyle BackColor="#BCBCBC"></HeaderStyle>
<Columns>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="确定" CancelText="取消" EditText="编辑">
<ItemStyle Wrap="False"></ItemStyle>
</asp:EditCommandColumn>
<asp:ButtonColumn Text="删除" CommandName="delete">
<ItemStyle Wrap="False"></ItemStyle>
</asp:ButtonColumn>
</Columns>
<PagerStyle Visible="False"></PagerStyle>
</asp:DataGrid>

Sub DataGrid1_update(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
Dim txtid, txttypeid, txtpro_id, txtpname, txtpimageurl, txtpsprice, txtphprice, txtpaddtime, txtpintro, txtcc, txtyxq As TextBox
txtid = e.Item.Cells(3).Controls(0)
txttypeid = e.Item.Cells(4).Controls(0)
txtpro_id = e.Item.Cells(5).Controls(0)
txtpname = e.Item.Cells(6).Controls(0)
txtpimageurl = e.Item.Cells(7).Controls(0)
txtpsprice = e.Item.Cells(8).Controls(0)
txtphprice = e.Item.Cells(9).Controls(0)
txtpaddtime = e.Item.Cells(10).Controls(0)
txtpintro = e.Item.Cells(11).Controls(0)
Dim strsql As String
strsql = "update product set typeid='" & txttypeid.Text & "',pro_id='" & txtpro_id.Text & "',pname='" & txtpname.Text & "',pimageurl='" & txtpimageurl.Text & "',psprice='" & txtpsprice.Text & "',phprice='" & txtphprice.Text & "',paddtime=#" & Now() & "#,pintro='" & txtpintro.Text & "' where id=" & DataGrid1.DataKeys(CInt(e.Item.ItemIndex))
Dim conn As New SqlConnection("server=(local);database=xf;uid=sa;pwd=;")
Dim cmd As New SqlCommand(strsql, conn)
Dim exp As Exception
Try
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
Catch exp
Label3.Text = "发生错误,没有正常更新记录,请重新修改!"
End Try
DataGrid1.EditItemIndex = -1
Call myDataBind()
End Sub

[此贴子已经被作者于2006-11-16 10:05:36编辑过]

strsql = "update product set id='" & txtid.Text & "',typeid='" & txttypeid.Text & "',pro_id='" & txtpro_id.Text & "',pname='" & txtpname.Text & "',pimageurl='" & txtpimageurl.Text & "',psprice='" & txtpsprice.Text & "',phprice='" & txtphprice.Text & "',paddtime=#" & Now() & "#,pintro='" & txtpintro.Text & "' where id=" & DataGrid1.DataKeys(CInt(e.Item.ItemIndex))

在这样的情况下，不可以以id做为修改的条件，同时又对id进行修改。

strsql = "update product set typeid='" & txttypeid.Text & "',pro_id='" & txtpro_id.Text & "',pname='" & txtpname.Text & "',pimageurl='" & txtpimageurl.Text & "',psprice='" & txtpsprice.Text & "',phprice='" & txtphprice.Text & "',paddtime=#" & Now() & "#,pintro='" & txtpintro.Text & "' where id=" & DataGrid1.DataKeys(CInt(e.Item.ItemIndex))

这样应该可以的

谢谢了,我再试一下吧

我试了,还是不行啊,

还有没有别的方法啊?

真的没有人搭理我吗?

那你把这条SQL语句输出来,放到查询分析器中去执行一下看有没有错误?

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
OleDbConnection Conn;
protected void Page_Load(Object Src, EventArgs E ) {
String Provider,DataBase,ConnStr,SQL;
Provider = "Microsoft.Jet.OLEDB.4.0;";
DataBase = Server.MapPath("person.mdb");
ConnStr = "Provider="+Provider+"Data Source="+DataBase;
Conn = new OleDbConnection(ConnStr);
if (!IsPostBack) BindGrid();
}
void DataGrid_Edit(Object sender,DataGridCommandEventArgs E){
dg.EditItemIndex = (int)E.Item.ItemIndex;
BindGrid();
}
void DataGrid_Cancel(Object sender,DataGridCommandEventArgs E){
dg.EditItemIndex = -1;
BindGrid();
}
void DataGrid_Update(Object sender,DataGridCommandEventArgs E){
String strSQL = "UPDATE grade SET "+
"姓名='"+((TextBox)E.Item.Cells[3].Controls[0]).Text
+"',数学="+((TextBox)E.Item.Cells[4].Controls[0]).Text
+" where 学号="+dg.DataKeys[(int)E.Item.ItemIndex];
OleDbCommand cm = new OleDbCommand(strSQL,Conn);
Conn.Open();
try {
cm.ExecuteNonQuery();
Message.InnerHtml="<b>编辑成功</b>";
// 退出编辑状态
dg.EditItemIndex=-1;
}
catch (OleDbException) {
Message.InnerHtml="编辑失败";
Message.Style["color"]="red";
}
cm.Connection.Close();
// 更新DataGrid
BindGrid();
}
// 处理删除事件
public void DataGrid_Delete(Object sender,DataGridCommandEventArgs E){
String strSQL="DELETE FROM grade WHERE 学号="
+ dg.DataKeys[(int)E.Item.ItemIndex];
OleDbCommand cm = new OleDbCommand(strSQL,Conn);
Conn.Open();
try {
cm.ExecuteNonQuery();
Message.InnerHtml = "<b>删除成功</b>";
}
catch (OleDbException){
Message.InnerHtml = "<b>删除失败</b>";
Message.Style["color"]="red";
}
Conn.Close();
BindGrid();
}
public void BindGrid() {
OleDbDataAdapter da=new OleDbDataAdapter("select * from grade",Conn);
DataSet ds = new DataSet();
da.Fill(ds);
dg.DataSource=ds;
dg.DataBind();
}
</script>
<body style="font: 10pt verdana">
<form runat="server">
<asp:DataGrid id="dg" runat="server"
Width="400" BackColor="#ccccff"
BorderColor="black" ShowFooter="false"
CellPadding=3 CellSpacing="0"
Font-Name="Verdana" Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
OnEditCommand="DataGrid_Edit"
OnCancelCommand="DataGrid_Cancel"
OnUpdateCommand="DataGrid_Update"
OnDeleteCommand="DataGrid_Delete"
DataKeyField="学号"
AutoGenerateColumns="false"
MaintainState="false">
<Columns>
<asp:EditCommandColumn EditText="编辑" CancelText="取消"
UpdateText="更新" ItemStyle-Wrap="false"/>
<asp:ButtonColumn Text="删除" CommandName="Delete" ItemStyle-Wrap="false"/>
<asp:BoundColumn HeaderText="学号" DataField="学号" ReadOnly="True"/>
<asp:BoundColumn HeaderText="姓名" DataField="姓名" />
<asp:BoundColumn HeaderText="数学" DataField="数学" />
</Columns>
</asp:DataGrid>
<span id="Message" MaintainState="false"
style="font: arial 11pt;" runat="server"/>
</form>
这个是不是你要的！
这是所有的代码！

有没有VB版本的啊

我先研究一下你这个,谢谢!

不好意思

没有。

其实知道思路自己想就可以了，应该可以想出来的！

加油哦。