基于数据库的课程管理设计方案 - 图文(6)

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

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库基于数据库的课程管理设计方案 - 图文(6)在线全文阅读。