------------------------------创建学生成绩表T_Students
CREATE TABLE T_Students(
StudentId uniqueidentifier,
SName nvarchar(10),
ClassId int,
TName nvarchar(10),
Sphone varchar(15),
SAddress nvarchar (50)
)
-----------------------------前台代码
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.style1
{
width: 194px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table style="width: 50%;">
<tr>
<td>
学生编号：</td>
<td class="style1">
<asp:TextBox ID="txtsid" runat="server" ReadOnly="true" Enabled="False"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td>
学生姓名：</td>
<td class="style1">
<asp:TextBox ID="txtsname" runat="server"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td>
班级编号：</td>
<td class="style1">
<asp:TextBox ID="txtclassid" runat="server"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td>
班主任姓名：</td>
<td class="style1">
<asp:TextBox ID="txtteachername" runat="server"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td>
联系电话：</td>
<td class="style1">
<asp:TextBox ID="txtphone" runat="server"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td>
家庭住址：</td>
<td class="style1">
<asp:TextBox ID="txtadress" runat="server"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td>
<asp:Button ID="btnadd" runat="server" Xonclick="btnadd_Click" Text="添加" />
</td>
<td class="style1">
<asp:Button ID="btnselect" runat="server" Text="查询" Xonclick="btnselect_Click" />
</td>
<td>
<asp:Button ID="btnupdate" runat="server" Text="更改" Xonclick="btnupdate_Click" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
--------------------------后台代码
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 新闻系统
{
public partial class Students : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
-----------------------------------添加
protected void btnadd_Click(object sender, EventArgs e)
{
string studentid=txtsid.Text.Trim();
string sname =txtsname.Text.Trim();
string classid=txtclassid.Text.Trim();
string tname=txtteachername.Text.Trim();
string sphone=txtphone.Text.Trim();
string saddress=txtadress.Text.Trim();
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into T_Students values(NEWID(),@SName,@ClassId,@TName,@Sphone,@SAddress)";
cmd.Parameters.Add(new SqlParameter("@SName", sname));
cmd.Parameters.Add(new SqlParameter("@ClassId", classid));
cmd.Parameters.Add(new SqlParameter("@TName", tname));
cmd.Parameters.Add(new SqlParameter("@Sphone",sphone));
cmd.Parameters.Add(new SqlParameter("@SAddress", saddress));
cmd.ExecuteNonQuery();
Response.Write("添加成功！");
}
}
}
-----------------------查询
protected void btnselect_Click(object sender, EventArgs e)
{
string sname = txtsname.Text.Trim();
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select StudentId,SName,ClassId,Tname,Sphone,SAddress from T_Students whereSName=@SName";
cmd.Parameters.Add(new SqlParameter("@SName",sname));
using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
adapter.Fill(dt);
//Response.Write( dt.Rows.Count);
txtsid.Text = dt.Rows[0]["StudentId"].ToString();
txtsname.Text = dt.Rows[0]["SName"].ToString();
txtclassid.Text = dt.Rows[0]["ClassId"].ToString();
txtteachername.Text = dt.Rows[0]["Tname"].ToString();
txtphone.Text = dt.Rows[0]["Sphone"].ToString();
txtadress.Text = dt.Rows[0]["SAddress"].ToString();
}
}
}
}
------------------------------修改
protected void btnupdate_Click(object sender, EventArgs e)
{
string studentid = txtsid.Text.Trim();
string sname = txtsname.Text.Trim();
string classid = txtclassid.Text.Trim();
string tname = txtteachername.Text.Trim();
string sphone = txtphone.Text.Trim();
string saddress = txtadress.Text.Trim();
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "update T_Students set SName=@sname,ClassId=@classid,TName=@tname,Sphone=@sphone,SAddress=@saddress where StudentId=@StudentId";
cmd.Parameters.Add(new SqlParameter("@sname", sname));
cmd.Parameters.Add(new SqlParameter("@classid", classid));
cmd.Parameters.Add(new SqlParameter("@tname", tname));
cmd.Parameters.Add(new SqlParameter("@sphone", sphone));
cmd.Parameters.Add(new SqlParameter("@saddress", saddress));
cmd.Parameters.Add(new SqlParameter("@StudentId",studentid));
cmd.ExecuteNonQuery();
}
}
}
}
}