增改查

来源：互联网发布：informix端口编辑：程序博客网时间：2024/06/08 10:41

<table >
     <tr><td>学生编号：<asp:TextBox ID="txtid" runat="server"></asp:TextBox></td> </tr>
     <tr><td>学生姓名：<asp:TextBox ID="txtname" runat="server"></asp:TextBox> </td></tr>
     <tr><td>班级编号：<asp:TextBox ID="txtclassid" runat="server"></asp:TextBox> </td></tr>
     <tr><td>班主任姓名：<asp:TextBox ID="txtTeaname" runat="server"></asp:TextBox> </td></tr>
     <tr><td>联系电话：<asp:TextBox ID="txtphone" runat="server"></asp:TextBox> </td></tr>
     <tr><td>家庭住址：<asp:TextBox ID="txtadress" runat="server"></asp:TextBox>
         <br />
         <br />
         <asp:Button ID="btninsert" runat="server" onclick="btninsert_Click"
             Text="添加信息" />
         <asp:Button ID="btnselect" runat="server" onclick="btnselect_Click"
             style="height: 21px" Text="查询信息" />
         <asp:Button ID="btnupdate" runat="server" onclick="btnupdate_Click"
             Text="更改信息" />
         </td></tr>
    </table>
    </div>
    </form>
</body>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

namespace students
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

}

        protected void btninsert_Click(object sender, EventArgs e)
        {
          string constr=ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
          using (SqlConnection con = new SqlConnection(constr))
            {
                con.Open();
              using(SqlCommand cmd=con.CreateCommand())
              {
                  cmd.CommandText = "insert into T_Students(id,Sname,Classid,TeaName,phone,Adreass)values(newid(),@name,@Classid,@teacher,@phone,@adress)";
                  cmd.Parameters.AddWithValue("@name",txtname.Text.Trim());
                  cmd.Parameters.AddWithValue("@Classid",txtclassid.Text.Trim());
                  cmd.Parameters.AddWithValue("@teacher",txtTeaname.Text.Trim());
                  cmd.Parameters.AddWithValue("@phone",txtphone.Text.Trim());
                  cmd.Parameters.AddWithValue("@adress",txtadress.Text.Trim());
                  int r=cmd.ExecuteNonQuery();
                  if(r>0)
                  {
                      Response.Write("添加成功!");

                  }

              }

            }
        }

        protected void btnselect_Click(object sender, EventArgs e)
        {
          string str=ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            using(SqlConnection con=new SqlConnection (str))
            {
                con.Open();
                using(SqlCommand cmd=con.CreateCommand())
                {
                    cmd.CommandText = "select id,Sname,Classid,TeaName,phone,Adreass from T_Students whereid=@id";
                    cmd.Parameters.AddWithValue("@id",txtid.Text.Trim());
                    DataSet ds = new DataSet();
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(ds);
                    if(ds.Tables[0].Rows.Count>0)
                    {
                        txtid.Text = ds.Tables[0].Rows[0]["id"].ToString();
                        txtname.Text = ds.Tables[0].Rows[0]["Sname"].ToString();
                        txtclassid.Text = ds.Tables[0].Rows[0]["Classid"].ToString();
                        txtTeaname.Text = ds.Tables[0].Rows[0]["TeaName"].ToString();
                        txtphone.Text = ds.Tables[0].Rows[0]["phone"].ToString();
                        txtadress.Text = ds.Tables[0].Rows[0]["Adreass"].ToString();
                    }

                }

            }
        }

        protected void btnupdate_Click(object sender, EventArgs e)
        {
          string constr=ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            using(SqlConnection con=new SqlConnection(constr))
            {
                con.Open();
                using(SqlCommand cmd=con.CreateCommand())
                {
                    cmd.CommandText = "update T_Students set Sname=@name,Classid=@classid,TeaName=@TeaName,phone=@phone,Adreass=@adreass whereid=@id";
                    cmd.Parameters.AddWithValue("@name", txtname.Text.Trim());
                    cmd.Parameters.AddWithValue("@Classid", txtclassid.Text.Trim());
                    cmd.Parameters.AddWithValue("@TeaName", txtTeaname.Text.Trim());
                    cmd.Parameters.AddWithValue("@phone", txtphone.Text.Trim());
                    cmd.Parameters.AddWithValue("@adreass", txtadress.Text.Trim());
                    cmd.Parameters.AddWithValue("@id", txtid.Text.Trim());
                    int r = cmd.ExecuteNonQuery();
                    if (r > 0)
                    {
                        Response.Write("更改成功！");

                    }
                }

            }
        }
    }
}