GridView中能删数据,不能更新,怎么办!

Question

我写的程序里,用了个GridView,是用三层写的,可以进行数据删除,也写了更新语句,也没有提示错误,但就是没对数据库进行操作.有没有哪位大哥遇到过这种问题?可以让小弟参考一下,小弟,在此谢谢!

Answer 1

this.BindingContext[DataSetName, TableName].EndCurrentEdit();
然后再执行更新
(如果你是操作的DataSet)

Answer 2

protected void btnUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                DataRow dr = thisTable.Rows.Find(this.TextID.Text);
                dr[thisTable.IDColumn] = Convert.ToInt32(this.TextID.Text);
                dr[thisTable.TitleColumn] = this.TextTitle.Text;
                dr[thisTable.CommentColumn] = this.txtMessage.Value;
                dr[thisTable.PublishDateColumn] = DTtemp;
                dr[thisTable.StatusColumn] = Convert.ToInt32(this.DropDownListStatus.SelectedValue);
                Message.UpdateMessageDataTable(thisTable);                Response.Write("<script>alert('修改成功！');</script>");
            }
            catch (Exception ex)
            {
                this.FormMessage.Style["color"] = "red";
                this.FormMessage.InnerHtml = "错误：" + this.FormMessage.InnerHtml + ex.Message.ToString();
            }        }我操作时是提示"修改成功",但没对数据库数据进行修改~谢谢

Answer 3

不好意思,上面的被我多弄掉了一句,我再发下
protected void btnUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                MessageDataTable thisTable = (MessageDataTable)ViewState["MessageDataTable"];                DataRow dr = thisTable.Rows.Find(this.TextID.Text);
                dr[thisTable.IDColumn] = Convert.ToInt32(this.TextID.Text);
                dr[thisTable.TitleColumn] = this.TextTitle.Text;
                dr[thisTable.CommentColumn] = this.txtMessage.Value;
                dr[thisTable.PublishDateColumn] = DTtemp;
                dr[thisTable.StatusColumn] = Convert.ToInt32(this.DropDownListStatus.SelectedValue);
                Message.UpdateMessageDataTable(thisTable);                Response.Write("<script>alert('修改成功！');</script>");
            }
            catch (Exception ex)
            {
                this.FormMessage.Style["color"] = "red";
                this.FormMessage.InnerHtml = "错误：" + this.FormMessage.InnerHtml + ex.Message.ToString();
            }        }