数据库增改查

 <form id="form1" runat="server">
    学生编号：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    <asp:Button ID="Button1" runat="server" Text="查询" onclick="Button1_Click" />
    <br />
    <br />
    学生编号：<asp:TextBox ID="txtstuid" runat="server"></asp:TextBox>
    <br />
    学生姓名：<asp:TextBox ID="txtstuname" runat="server"></asp:TextBox>
    <br />
    班级编号：<asp:TextBox ID="txtclaid" runat="server"></asp:TextBox>
    <br />
    班主任姓名：<asp:TextBox ID="txtbzrxm" runat="server"></asp:TextBox>
    <br />
    联系电话：<asp:TextBox ID="txtphone" runat="server"></asp:TextBox>
    <br />
    家庭住址：<asp:TextBox ID="txtaddress" runat="server"></asp:TextBox>
    <br />
    <asp:Button ID="Button2" runat="server" Text="添加" onclick="Button2_Click" />
    <asp:Button ID="Button3" runat="server" Text="修改" onclick="Button3_Click" />
    </form>

---------------------后台部分-------------------------------

---------------------------------查询部分-----------------------------------

 string connstr = "data source=QZC-PC;DATABASE=News;INTEGRATED SECURITY=TRUE";
        protected void Button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(connstr);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT stuid,StuName,ClassId,BZUPhone,Mobile,Address FROM T_Students WHERE stuid=@Sid ";
            cmd.Parameters.AddWithValue("@Sid",TextBox1.Text.Trim());
            DataTable dt = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            adapter.Fill(dt);
           
            txtstuid.Text = dt.Rows[0]["stuid"].ToString();
            txtstuname.Text = dt.Rows[0]["StuName"].ToString();
            txtclaid.Text = dt.Rows[0]["ClassId"].ToString();
            txtbzrxm.Text = dt.Rows[0]["BZUPhone"].ToString();
            txtphone.Text = dt.Rows[0]["Mobile"].ToString();
            txtaddress.Text = dt.Rows[0]["Address"].ToString();
        }

-=-----------------------------插入部分---------------------------------------------

        protected void Button2_Click(object sender, EventArgs e)
        {
             SqlConnection conn = new SqlConnection(connstr);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "insert into T_Students(stuid,StuName,ClassId,BZUPhone,Mobile,Address)values(NEWID(),@StuName,@ClassId,@BZUPhone,@Mobile,@Address)";
            cmd.Parameters.AddWithValue("@StuName",txtstuname.Text.Trim());
            cmd.Parameters.AddWithValue("@ClassId", txtclaid.Text.Trim());
            cmd.Parameters.AddWithValue("@BZUPhone",txtbzrxm.Text.Trim());
            cmd.Parameters.AddWithValue("@Mobile",txtphone.Text.Trim());
            cmd.Parameters.AddWithValue("@Address",txtaddress.Text.Trim());
            int n=cmd.ExecuteNonQuery();
            if(n>0)
            {
                Response.Write("插入成功！");
            }
        }

--------------------------修改部分---------------------------------------------------------

        protected void Button3_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(connstr);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "update T_Students set ClassId=@ClassId,BZUPhone=@BZUPhone,Mobile=@Mobile,Address=@Address,StuName=@StuName where stuid=@stuid";
            cmd.Parameters.AddWithValue("@ClassId",txtclaid.Text.Trim());
            cmd.Parameters.AddWithValue("@BZUPhone",txtbzrxm.Text.Trim());
            cmd.Parameters.AddWithValue("@Mobile",txtphone.Text.Trim());
            cmd.Parameters.AddWithValue("@Address",txtaddress.Text.Trim());
            cmd.Parameters.AddWithValue("@StuName",txtstuname.Text.Trim());
            cmd.Parameters.AddWithValue("@stuid",txtstuid.Text.Trim());
            int n=cmd.ExecuteNonQuery();
            if(n>0)
            {
                Response.Write("修改成功！");
            }
        }
    }
}