webform1.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="dynamicweb8_14.WebForm1" %>
<!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">
<div style="width:100%;margin:0 auto;overflow:scroll;">
<center><h3>查询学生信息</h3></center>
专业:<asp:DropDownList ID="ddlMajor" runat="server" AutoPostBack="True" DataSourceID="sdsMajor" DataTextField="major" DataValueField="major" OnSelectedIndexChanged="ddlMajor_SelectedIndexChanged"></asp:DropDownList>
<asp:SqlDataSource ID="sdsMajor" runat="server" ConnectionString="<%$ ConnectionStrings:cnStudent %>" SelectCommand="SELECT DISTINCT [major] FROM [student]"></asp:SqlDataSource>
<br />
<asp:GridView ID="GridView1" runat="server" HorizontalAlign="Center" Width="600px" Font-Size="Small" OnDataBound="GridView1_DataBound"></asp:GridView>
</div>
</form>
</body>
</html>
webform1.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace dynamicweb8_14
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlMajor.DataBind();
ListItem item = new ListItem("请选择专业","");
ddlMajor.Items.Insert(0, item);
ddlMajor.SelectedIndex = 0;
}
}
protected void GridView1_DataBound(object sender, EventArgs e)
{
GridViewRow headerRow = GridView1.HeaderRow;
headerRow.Cells[0].Text = "学号";
headerRow.Cells[1].Text = "姓名";
headerRow.Cells[2].Text = "性别";
headerRow.Cells[3].Text = "出生日期";
headerRow.Cells[4].Text = "专业";
headerRow.Cells[5].Text = "是否党员";
headerRow.Cells[6].Text = "电子邮件";
}
protected void ddlMajor_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlMajor.SelectedIndex != 0)
{
string cnString = System.Configuration.ConfigurationManager.ConnectionStrings["cnStudent"].ToString();
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(cnString);
con.Open();
string sql = "select * from student where major=@major";
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(sql, con);
adapter.SelectCommand.Parameters.AddWithValue("@major", ddlMajor.SelectedValue);
System.Data.DataSet ds = new System.Data.DataSet();
adapter.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
GridView1.Visible = true;
}
else
{
GridView1.Visible = false;
}
}
}
}
web.config
<?xml version="1.0" encoding="utf-8"?>
<!--
有关如何配置 ASP.NET 应用程序的详细信息,请访问
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<connectionStrings>
<add name="cnStudent" connectionString="Data Source=LAPTOP-AQKEN65V\SQLEXPRESS08;Initial Catalog=studentMIS;Persist Security Info=True;User ID=sa;Password=123456"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.5" />
<httpRuntime targetFramework="4.5" />
</system.web>
</configuration>
sql
--学生管理系统库
create database studentMIS;
use studentMIS;
--学生表
create table student(
stu_id nvarchar(8) not null,
stu_name nvarchar(8) not null,
sex nvarchar(2) not null,
birth_date datetime,
major nvarchar(50) not null,
isCPC bit,
email nvarchar(20),
primary key(stu_id)
);
--课程表
create table course(
course_id smallint identity(1,1) not null,
course_name nvarchar(50) not null
);
--成绩表
create table result(
stu_id nvarchar(8) not null,
course_id smallint not null,
mark decimal(6,0) not null,
primary key(stu_id,course_id)
);
insert into student values('20160101','王霞','女','1998-10-23','计算机信息管理','true','wx@163.com');
insert into student values('20160102','张大力','男','1998-07-02','计算机信息管理','false','zdf@163.com');
insert into student values('20160103','李长军','男','1998-5-14','计算机信息管理','false','lcj@163.com');
insert into student values('20160104','韩华东','男','1998-12-07','计算机信息管理','false','8562478@qq.com');
insert into student values('20160105','万芳','女','1998-01-27','软件技术','false','5478518@qq.com');
insert into student values('20160106','赵中千','男','1998-08-12','软件技术','true','5582178@qq.com');
insert into student values('20160107','吴空俊','男','1998-05-21','软件技术','false','4845512@qq.com');
insert into student values('20160108','方文其','男','1998-06-05','软件技术','false','8412563@qq.com');
insert into student values('20160109','唐汉','男','1998-04-18','计算机应用','false','1546315@qq.com');
insert into student values('20160110','刘含斌','男','1998-10-07','计算机应用','false','741526@qq.com');
insert into course values('高等数学');
insert into course values('大学英语');
insert into course values('邓小平理论概述');
insert into course values('毛泽东思想概述');
insert into course values('C语言程序设计');
insert into course values('数据结构');
insert into result values('20160101',1,'71');
insert into result values('20160101',2,'72');
insert into result values('20160101',3,'73');
insert into result values('20160101',4,'74');
insert into result values('20160101',5,'75');
insert into result values('20160101',6,'76');
insert into result values('20160102',1,'60');
insert into result values('20160102',2,'61');
insert into result values('20160102',3,'60');
insert into result values('20160102',4,'62');
insert into result values('20160102',5,'60');
insert into result values('20160102',6,'59');