<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" οnclick="btninsert_Click"
Text="添加信息" />
<asp:Button ID="btnselect" runat="server" οnclick="btnselect_Click"
style="height: 21px" Text="查询信息" />
<asp:Button ID="btnupdate" runat="server" οnclick="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 where id=@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 where id=@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("更改成功!");
}
}
}
}
}
}