1.新建一个DataConn.aspx页面,在该页面中添加一个TextBox控件,在该控件中用户可以输入学生的姓名。
2.在DataConn.aspx页面中添加一个按钮控件,用户点击按钮,系统根据用户输入的学生姓名查询MyPetShop.mdf数据库中“Student”表中该生的各科成绩,并通过GridView控件显示该生的各科成绩。
DataConn.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DataConn.aspx.cs" Inherits="WebApplication233.DataConn" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
姓名:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><asp:Button ID="Button1" runat="server" Text="查询" OnClick="Button1_Click" />
<br />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</form>
</body>
</html>
DataConn.aspx.cs
using System;
using System.Data.SqlClient;
namespace WebApplication1 {
public partial class DataConn : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
}
protected void Button1_Click(object sender, EventArgs e) {
string conn = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\MyPetShop.mdf;Integrated Security=True";
SqlConnection c = new SqlConnection(conn);
string sql = "SELECT * FROM Student WHERE 姓名=@name";
SqlCommand cmd = new SqlCommand(sql,c);
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("name", TextBox1.Text);
try {
cmd.Connection.Open();
SqlDataReader dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
dr.Close();
}
catch (SqlException ex) {
}
finally {
cmd.Connection.Close();
}
}
}
}
实验结果: