不能更新数据，搞得我云里雾里了

Question

下面是代码
protected void GridView1_OnUpdateCommand(object sender, GridViewUpdateEventArgs e)
    {
        string id = GridView1.DataKeys[e.RowIndex].Values.ToString();
        GridViewRow gvr = GridView1.Rows[e.RowIndex];
        string strstuID = ((TextBox)gvr.FindControl("txtstuID")).Text;
        string strstuName = ((TextBox)gvr.FindControl("txtstuName")).Text;
        string strstuPwd = ((TextBox)gvr.FindControl("txtstuPwd")).Text;
        string strstuEmail = ((TextBox)gvr.FindControl("txtstuEmail")).Text;
         try
        {         
            SqlConnection conn = DB.createrDB();
            if (conn.State.ToString() == "Closed") conn.Open();
            SqlCommand comm = new SqlCommand("update student set stuID='" + strstuID + "',stuName='" + strstuName + "',stuPwd='" + strstuPwd + "',stuEmail='" + strstuEmail + "' where id='" + id + "'", conn);
            comm.ExecuteNonQuery();                      
            conn.Close();
            if (conn.State.ToString() == "Open") conn.Close();
            this.GridView1.EditIndex = -1;
            Alert("记录成功更新");
            SetBind();
        }
        catch (Exception ex)
        {
            Alert(ex.Message);
        }
        
    }
    private void Alert(string strMessage)
    {
        Response.Write("<script>alert('" + strMessage + "');</script>");
    }源码：
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataKeyNames="id" OnRowEditing="GridView1_OnRowCommand" OnRowCancelingEdit="GridView1_OnCancelCommand" OnRowUpdating="GridView1_OnUpdateCommand">
                    <Columns>
                    <asp:TemplateField HeaderText="序号">
                      <ItemTemplate>
                        <%# Eval("id") %>
                      </ItemTemplate>
                      </asp:TemplateField>
                    <asp:TemplateField HeaderText="学号">
                      <ItemTemplate>
                        <%# Eval("stuID") %>
                      </ItemTemplate>
                      <EditItemTemplate>
                          <asp:TextBox ID="txtstuID" runat="server" Text=' <%# Eval("stuID") %>'></asp:TextBox>
                      </EditItemTemplate>
                    </asp:TemplateField>
                    
                      <asp:TemplateField HeaderText="姓名">
                      <ItemTemplate>
                        <%# Eval("stuName") %>
                      </ItemTemplate>
                      <EditItemTemplate>
                          <asp:TextBox ID="txtstuName" runat="server" Text='<%# Eval("stuName") %>'></asp:TextBox>
                      </EditItemTemplate>
                    </asp:TemplateField>
                      <asp:TemplateField HeaderText="密码">
                      <ItemTemplate>
                        <%# Eval("stuPwd") %>
                      </ItemTemplate>
                      <EditItemTemplate>
                          <asp:TextBox ID="txtstuPwd" runat="server" Text='<%# Eval("stuPwd") %>'></asp:TextBox>
                      </EditItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="邮箱">
                      <ItemTemplate>
                        <%# Eval("stuEmail") %>
                      </ItemTemplate>
                      <EditItemTemplate>
                          <asp:TextBox ID="txtstuEmail" runat="server" Text='<%# Eval("stuEmail") %>'></asp:TextBox>
                      </EditItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="编辑">
                      <ItemTemplate>
                      <asp:ImageButton ID="ImageButton1" runat="server" CommandName="Edit"  ImageUrl="images/bianji.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
                      </ItemTemplate>
                      <EditItemTemplate>
                      <asp:ImageButton ID="ImageButton3" runat="server" CommandName="Update" ImageUrl="images/updata.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
                      <asp:ImageButton ID="ImageButton4" runat="server" CommandName="Cancel" ImageUrl="images/cancel.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
                      </EditItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="删除">
                      <ItemTemplate>
                      <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="images/shanchu.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
                      </ItemTemplate>
                    </asp:TemplateField>
                    
                    
                    </Columns>
                    
                    </asp:GridView>

Answer 1

<asp:LinkButton ID="LinkButton3" runat="server" 
                                                                    CommandArgument='<%# DataBinder.Eval(Container.DataItem, "id")%>' 
                                                                    CommandName="GuanLi_getID" Enabled="False" ToolTip="网站管理。">删除</asp:LinkButton>

Answer 2

http://blog.csdn.net/xianfajushi/archive/2008/11/30/3413317.aspx

Answer 3

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class userInfo : System.Web.UI.Page{ 
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["adminId"] == "adminID")
        {
            Response.Redirect("login.aspx");
        }
        else
        {
            this.Label1.Text = Convert.ToString(Session["adminId"]);
        }
        //在此处放置用户代码以初始化页面
        if (!IsPostBack)
        {
            SetBind();
        }
     
    }    protected void SetBind()
    {
       
        try
        {
            SqlConnection con = DB.createrDB();
            if (con.State.ToString() == "Closed") con.Open();     
            SqlCommand cmd = new SqlCommand("select * from student ", con);
            DataSet ds = new DataSet();
            SqlDataAdapter sda = new SqlDataAdapter();
            sda.SelectCommand = cmd;
            sda.Fill(ds);
            this.GridView1.DataSource = ds;
            this.GridView1.DataBind();
            if (con.State.ToString() == "Open") con.Close();
        }
        finally
        {
         
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
          SqlConnection con = DB.createrDB();
          if (con.State.ToString() == "Closed") con.Open();
            SqlCommand comm = new SqlCommand("insert into student (stuID,stuName,stuPwd,stuEmail) values (@stuID,@stuName,@stuPwd,@stuEmail)", con);
            SqlParameter parm1 = new SqlParameter("@stuID", SqlDbType.VarChar, 15);
            parm1.Value = this.ID.Text;
            SqlParameter parm2 = new SqlParameter("@stuName", SqlDbType.VarChar, 10);
            parm2.Value = this.Name.Text;
            SqlParameter parm3 = new SqlParameter("@stuPwd", SqlDbType.VarChar, 10);
            parm3.Value = this.Pwd.Text;
            SqlParameter parm4 = new SqlParameter("@stuEmail", SqlDbType.NVarChar, 50);
            parm4.Value = this.Email.Text;
            comm.Parameters.Add(parm1);
            comm.Parameters.Add(parm2);
            comm.Parameters.Add(parm3);
            comm.Parameters.Add(parm4);            comm.ExecuteNonQuery();
            if (con.State.ToString() == "Open") con.Close();
            SetBind();
       
    }    protected void GridView1_OnRowCommand(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        SetBind();
    }
    protected void GridView1_OnCancelCommand(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex =-1;
        SetBind();
    }
    protected void GridView1_OnUpdateCommand(object sender, GridViewUpdateEventArgs e)
    {
        string id = GridView1.DataKeys[e.RowIndex].Values.ToString();
        GridViewRow gvr = GridView1.Rows[e.RowIndex];
        string strstuID = ((TextBox)gvr.FindControl("txtstuID")).Text;
        string strstuName = ((TextBox)gvr.FindControl("txtstuName")).Text;
        string strstuPwd = ((TextBox)gvr.FindControl("txtstuPwd")).Text;
        string strstuEmail = ((TextBox)gvr.FindControl("txtstuEmail")).Text;
       
          try
        {     
           
            SqlConnection conn = DB.createrDB();
            if (conn.State.ToString() == "Closed") conn.Open();
            SqlCommand comm = new SqlCommand("update student set stuID='" + strstuID + "',stuName='" + strstuName + "',stuPwd='" + strstuPwd + "',stuEmail='" + strstuEmail + "' where id='" + id + "'", conn);
            comm.ExecuteNonQuery();                     
            conn.Close();
            if (conn.State.ToString() == "Open") conn.Close();
            this.GridView1.EditIndex = -1;
            Alert("记录成功更新");
            SetBind();
        }
     
        catch (Exception ex)
        {
            Alert(ex.Message);
        }
       
    }
    //private void GridView1_OnDeleteCommand(object sender, GridViewDeleteEventArgs e)
    //{    //}
    private void Alert(string strMessage)
    {
        Response.Write(" <script>alert('" + strMessage + "'); </script>");
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string id = GridView1.DataKeys[e.RowIndex].Values.ToString();
        try
        {
         
            SqlConnection conn = DB.createrDB();
            if (conn.State.ToString() == "Closed") conn.Open();
            SqlCommand comm = new SqlCommand("delete from student  where id='" + id + "'", conn);
            comm.ExecuteNonQuery();
            conn.Close();
            if (conn.State.ToString() == "Open") conn.Close();
            this.GridView1.EditIndex = -1;
           
            SetBind();
        }        catch (Exception ex)
        {
            Alert(ex.Message);
        }
    }
}源码区：<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataKeyNames="id" OnRowEditing="GridView1_OnRowCommand" OnRowCancelingEdit="GridView1_OnCancelCommand" OnRowUpdating="GridView1_OnUpdateCommand" OnRowDeleting="GridView1_RowDeleting" BorderStyle="Dotted" >
                    <Columns>
                    <asp:TemplateField HeaderText="序号">
                      <ItemTemplate>
                        <%# Eval("id") %>
                      </ItemTemplate>
                      </asp:TemplateField>
                    <asp:TemplateField HeaderText="学号">
                      <ItemTemplate>
                        <%# Eval("stuID") %>
                      </ItemTemplate>
                      <EditItemTemplate>
                          <asp:TextBox ID="txtstuID" runat="server" Text=' <%# Eval("stuID") %>'> </asp:TextBox>
                      </EditItemTemplate>
                    </asp:TemplateField>
                   
                      <asp:TemplateField HeaderText="姓名">
                      <ItemTemplate>
                        <%# Eval("stuName") %>
                      </ItemTemplate>
                      <EditItemTemplate>
                          <asp:TextBox ID="txtstuName" runat="server" Text=' <%# Eval("stuName") %>'> </asp:TextBox>
                      </EditItemTemplate>
                    </asp:TemplateField>
                      <asp:TemplateField HeaderText="密码">
                      <ItemTemplate>
                        <%# Eval("stuPwd") %>
                      </ItemTemplate>
                      <EditItemTemplate>
                          <asp:TextBox ID="txtstuPwd" runat="server" Text=' <%# Eval("stuPwd") %>'> </asp:TextBox>
                      </EditItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="邮箱">
                      <ItemTemplate>
                        <%# Eval("stuEmail") %>
                      </ItemTemplate>
                      <EditItemTemplate>
                          <asp:TextBox ID="txtstuEmail" runat="server" Text=' <%# Eval("stuEmail") %>'> </asp:TextBox>
                      </EditItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="编辑">
                      <ItemTemplate>
                      <asp:ImageButton ID="ImageButton1" runat="server" CommandName="Edit"  ImageUrl="images/bianji.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
                      </ItemTemplate>
                      <EditItemTemplate>
                      <asp:ImageButton ID="ImageButton3" runat="server" CommandName="Update" ImageUrl="images/updata.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
                      <asp:ImageButton ID="ImageButton4" runat="server" CommandName="Cancel" ImageUrl="images/cancel.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
                      </EditItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="删除">
                      <ItemTemplate>
                      <asp:ImageButton ID="ImageButton2" runat="server" CommandArgument=' <%# DataBinder.Eval(Container.DataItem, "id")%>' CommandName="Delete" ImageUrl="images/shanchu.jpg" BorderWidth="0" ImageAlign="absMiddle"/>
                      </ItemTemplate>
                    </asp:TemplateField>
                   
                   
                    </Columns>
                   
                    </asp:GridView>
                 
数据库:
id int
stuID varhcar(15) primary key,
stuName varchar(10),
stuPwd varchar(10),
stuEmail nvarchar(50)