int numberOfRow; string sTime; int i;
protected void Page_Load(object sender, EventArgs e) {
mysqlconnection = new SqlConnection(ConfigurationManager.ConnectionStrings[\学生成绩智能管理系统ConnectionString\
SqlCommand mysqlcommand = mysqlconnection.CreateCommand();
mysqlcommand.CommandText = \学号) as 最大学号 from 学生表\ myadapter = new SqlDataAdapter();
myadapter.SelectCommand = mysqlcommand; myDataSet = new DataSet(); mysqlconnection.Open();
numberOfRow = myadapter.Fill(myDataSet, \学生表\ mysqlconnection.Close(); tb = myDataSet.Tables[\学生表\
TextBox1.Text=Convert.ToString(myDataSet.Tables[\学生表\最大学号\ Button2.Enabled = false; Button3.Enabled = false; if (!IsPostBack) {
for (i = 1970; i < 2030; i++) {
this.DropDownList1.Items.Add(Convert.ToString(i)); this.DropDownList4.Items.Add(Convert.ToString(i)); }
for (i = 1; i <= 12; i++) {
24
this.DropDownList2.Items.Add(Convert.ToString(i)); this.DropDownList5.Items.Add(Convert.ToString(i)); }
for (i = 1; i <= 31; i++) {
this.DropDownList3.Items.Add(Convert.ToString(i)); this.DropDownList6.Items.Add(Convert.ToString(i)); } } }
protected void Button2_Click(object sender, EventArgs e) {
if (TextBox2.Text == \ {
Response.Write(\请完善信息!');\ Button3.Enabled = false; } else {
Button2.Enabled = false; Button3.Enabled = true; } }
protected void Button3_Click(object sender, EventArgs e) {
myDataSet.Clear();
SqlCommand mysqlcommand = mysqlconnection.CreateCommand(); myadapter.SelectCommand = mysqlcommand;
mysqlcommand.CommandText = \学生表\
25
mysqlconnection.Open();
numberOfRow = myadapter.Fill(myDataSet, \学生表\ tb = myDataSet.Tables[\学生表\ dtr = tb.NewRow();
sTime = DropDownList1.Text + \ dtr[\学号\ dtr[\姓名\ dtr[\性别\ dtr[\院系\ dtr[\出生日期\ dtr[\家庭住址\
sTime = DropDownList4.Text + \ dtr[\入学时间\ dtr[\政治面貌\ dtr[\备注\ tb.Rows.Add(dtr);
SqlCommandBuilder scb = new SqlCommandBuilder(myadapter); myadapter.Update(myDataSet.Tables[\学生表\
Response.Write(\信息添加成功！');\ mysqlconnection.Close(); }
protected void Button1_Click(object sender, EventArgs e) {
mysqlconnection.Open();
SqlCommand coutsqlcommand = mysqlconnection.CreateCommand(); if(TextBox2.Text!=\ {
coutsqlcommand.CommandText = \数目 from 学生表 where 学号=\\
26
returnValue = (int)coutsqlcommand.ExecuteScalar(); mysqlconnection.Close(); if (returnValue == 1) {
Response.Write(\学号已存在!');\ Button3.Enabled = false; Button2.Enabled = false; } else {
Response.Write(\学号可以用!');\ Button3.Enabled = false; Button2.Enabled = true; } } else
Response.Write(\请输入学号!');\ } }
27
教师信息管理界面
图2.4 教师信息管理界面
也是分为教师信息浏览，教师信息查询，教师信息修改，教师信息删除，教师信息插入， 跟学生信息管理操作流程一样，只是修改部分数据表还有代码。
28