与数据库简单的操作，没有封装到类里面
在数据库中建立表
CREATE TABLE [dbo].[TStudent](
[sid] [int] NULL,
[sname] [nvarchar](50) NULL,
[sex] [nchar](10) NULL,
[saddress] [nvarchar](50) NULL,
[phone] [nvarchar](20) NULL
) ON [PRIMARY]
VS中新建三个页面
第一个页面HTML布局（Add.aspx）
学生学号： <input id="TextSid" style="width: 270px" runat="server" type="text" /><br>
学生姓名：<input id="TextName" style="width: 270px" runat="server" type="text" /><br>
学生性别：<input id="TextSex" style="width: 270px" runat="server" type="text" /><br>
学生住址：<input id="TextAddress" style="width: 270px" runat="server" type="text" /><br>
学生电话：<input id="TextPhone" style="width: 270px" runat="server" type="text" /><br>
<input id="BtAdd" type="button" value="添加" runat="server" onserverclick="BtAdd_ServerClick" />
<input id="BtClear" type="button" value="清空" runat="server" onserverclick="BtClear_ServerClick"/><a href="Show.aspx">查看</a>
此页面的后台代码：
private string str = "Data Source=服务器;Initial Catalog=数据库;Integrated Security=True";
protected void BtAdd_ServerClick(object sender, EventArgs e)
{
string insert = "insert into TStudent (sid,sname,sex,saddress,phone) values (" + Convert.ToInt32(TextSid.Value) + ",'" + TextName.Value + "','" + TextSex.Value + "','" + TextAddress.Value + "','" + TextPhone.Value + "')";
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlCommand cmd = new SqlCommand(insert, conn);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Response.Write("<script>alert('添加成功.')</script>");
}
else
{
Response.Write("<script>alert('添加失败.')</script>");
}
conn.Close();
}
protected void BtClear_ServerClick(object sender, EventArgs e)
{
TextAddress.Value = "";
TextName.Value = "";
TextPhone.Value = "";
TextSex.Value = "";
TextSid.Value = "";
}
第二个页面（Show.aspx）
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="Sid" HeaderText="学号" />
<asp:BoundField DataField="Sname" HeaderText="姓名" />
<asp:BoundField DataField="SAddress" HeaderText="住址" />
<asp:BoundField DataField="Phone" HeaderText="电话" />
<asp:HyperLinkField DataNavigateUrlFields="Sid" DataNavigateUrlFormatString="Change.aspx?id={0}"
HeaderText="修改" Text="修改" />
</Columns>
</asp:GridView>
后台代码：
private string str = "Data Source=服务器;Initial Catalog=数据库;Integrated Security=True";
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(str);
SqlDataAdapter ad = new SqlDataAdapter("select * from TStudent", conn);
DataSet set = new DataSet();
ad.Fill(set);
GridView1.DataSource = set.Tables[0];
GridView1.DataBind();
}
修改页面（Change.aspx）
学生学号：<input id="TextSid" style="width: 270px" runat="server" type="text" disabled="disabled" /><br>
学生姓名：<input id="TextName" style="width: 270px" runat="server" type="text" /><br>
学生性别：<input id="TextSex" style="width: 270px" runat="server" type="text" /><br>
学生住址：<input id="TextAddress" style="width: 270px" runat="server" type="text" /><br>
学生电话：<input id="TextPhone" style="width: 270px" runat="server" type="text" /><br>
<input id="BtChange" type="button" value="修改" runat="server" onserverclick="BtChange_ServerClick" /><a href="Show.aspx">放弃</a>
后台代码
private string str = "Data Source=服务器;Initial Catalog=数据库;Integrated Security=True";
protected void Page_Load(object sender, EventArgs e)
{
int sid = Convert.ToInt32(Request.QueryString["id"]);
if (sid.ToString() == null)
{
sid = 1;
}
SqlConnection conn = new SqlConnection(str);
SqlDataAdapter ad = new SqlDataAdapter("select * from TStudent where sid=" + sid, conn);
DataSet set = new DataSet();
ad.Fill(set);
TextSid.Value = set.Tables[0].Rows[0][0].ToString();
TextName.Value = set.Tables[0].Rows[0][1].ToString();
TextSex.Value = set.Tables[0].Rows[0][2].ToString();
TextAddress.Value = set.Tables[0].Rows[0][3].ToString();
TextPhone.Value = set.Tables[0].Rows[0][4].ToString();
}
protected void BtChange_ServerClick(object sender, EventArgs e)
{
string update = "update TStudent set sname='" + TextName.Value + "',sex='" + TextSex.Value + "',saddress='" + TextAddress.Value + "',phone='" + TextPhone.Value + "' where sid=" + Convert.ToInt32(TextSid.Value) + ")";
SqlConnection conn = new SqlConnection(str);
conn.Open();
try
{
SqlCommand cmd = new SqlCommand(update, conn);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Response.Write("<script>alert('修改成功.')</script>");
}
else
{
Response.Write("<script>alert('修改失败.')</script>");
}
}
catch(Exception err)
{
Response.Write("<script>alert('" + err + "')</script>");
}
conn.Close();
}