2020-11-03
VS中查询的使用方法
BLL
//获取学生信息
public static DataTable stu_result(string StuId = null, string Snumber = null)
{
return StudentsDAL.stu_result(StuId, Snumber);
}
DAL
//获取学生信息
public static DataTable stu_result(string StuId, string Snumber)
{
string sql = "select * from Students a inner join Scores b on a.StuId=b.StuId Where 1=1";
if (StuId != "" && StuId != null)
{
sql += " and a.StuId =" + StuId;
}
if (Snumber != "" && Snumber != null)
{
sql += " and Snumber like'%" + Snumber + "%'";
}
DataTable dt = DBHelper.ExcuteTable(sql);
if (dt.Rows.Count > 0)
{
return dt;
}
return null;
}
UI
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
}
private void Bind()
{
// string StuId = User.Identity.Name;
string StuId = this.txt_StuId.Text;
string Snumber = this.txt_Snumber.Text;
this.GridView1.DataSource = StudentsBLL.stu_result(StuId,Snumber);
this.GridView1.DataBind();
}
//查询
protected void Button1_Click(object sender, EventArgs e)
{
Bind();
}
<title>成绩查询</title>
<style type="text/css">
#div1{
text-align:center;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="div1">
学生学号: <asp:TextBox ID="txt_StuId" runat="server"></asp:TextBox>
<%-- 性别:<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>男</asp:ListItem>
<asp:ListItem>女</asp:ListItem>
</asp:DropDownList>--%>
试卷编号:<asp:TextBox ID="txt_Snumber" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="查询" Height="27px" Width="50px" OnClick="Button1_Click" />
</div>
<div id="div2">
<asp:GridView ID="GridView1" runat="server" HorizontalAlign="Center" AutoGenerateColumns="False" Height="287px" Width="703px">
<Columns>
<asp:BoundField DataField="StuId" HeaderText="学生id" />
<asp:BoundField DataField="StuName" HeaderText="学生姓名" />
<asp:BoundField DataField="StuSex" HeaderText="性别" />
<asp:BoundField DataField="Snumber" HeaderText="试卷编号" />
<asp:BoundField DataField="score" HeaderText="成绩" />
<asp:BoundField DataField="Role" HeaderText="角色" />
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>