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)