<form id="form1" runat="server"> 学生编号：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <asp:Button ID="Button1" runat="server" Text="查询" οnclick="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="添加" οnclick="Button2_Click" /> <asp:Button ID="Button3" runat="server" Text="修改" οnclick="Button3_Click" /> </form>
---------------后台部分-----------------
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Data;
namespace _2013_3_4sql复习{ public partial class Demo2 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) {
} 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("修改成功！"); } } }}
转载于:https://www.cnblogs.com/qzc900809/archive/2013/03/04/2943363.html
相关资源：jeecg-boot-2.1 Online表单 增量升级SQL