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

TextBox2.ReadOnly = false; TextBox3.ReadOnly = false; Label1.Text = \新用户名\ Label2.Text = \密码\ Label3.Text = \备注\ Label4.Visible = false; TextBox1.Text = \ TextBox2.Text = \ TextBox3.Text = \ }

protected void Button7_Click(object sender, EventArgs e) {

Label1.Text = \删除用户\ Button4.Visible = true; Button5.Visible = true; Button5.Enabled = false; TextBox4.Visible = false; TextBox1.ReadOnly = false; TextBox2.ReadOnly = false; TextBox3.ReadOnly = true; Label2.Text = \密码\ Label3.Text = \备注\ Label4.Visible = false; TextBox1.Text = \ TextBox2.Text = \ TextBox3.Text = \ Button4.Text = \确定\ Button5.Text = \提交删除\

TextBox3.Text = \请输入要删除的用户名和密码!\

14

}

protected void Button5_Click1(object sender, EventArgs e) {

if (Label1.Text == \删除用户\ {

SqlCommand coutsqlcommand = mysqlconnection.CreateCommand(); mysqlconnection.Open();

coutsqlcommand.CommandText = \ from 用户表 where 用户名=\+ \+ Convert.ToString(TextBox1.Text) + \密码=\ returnValue = coutsqlcommand.ExecuteNonQuery(); if (returnValue == 1) {

Response.Write(\删除成功');\ } else {

Response.Write(\未知错误！');\ }

Button5.Enabled = false; Button4.Enabled = true; } }

protected void Button8_Click(object sender, EventArgs e) { } }

15

学生信息管理界面

图2.3 学生信息管理界面

具体代码实现的过程 学生信息浏览代码

protected void Page_Load(object sender, EventArgs e) {

mysqlconnection = new SqlConnection(ConfigurationManager.ConnectionStrings[\学生成绩智能管理系统ConnectionString\

SqlCommand mysqlcommand = mysqlconnection.CreateCommand(); mysqlcommand.CommandText = \学生表\ myadapter = new SqlDataAdapter();

myadapter.SelectCommand = mysqlcommand; myDataSet = new DataSet(); mysqlconnection.Open();

int numberOfRow = myadapter.Fill(myDataSet, \学生表\

this.GridView1.DataSource = new DataView(myDataSet.Tables[\学生表\

16

this.GridView1.DataBind();

Label1.Text = \共有\名用户\ } 学生信息查询 public

SqlDataAdapter myadapter; SqlCommandBuilder scb; DataSet myDataSet;

SqlConnection mysqlconnection; SqlCommand mysqlcommand;

protected void Page_Load(object sender, EventArgs e) {

mysqlconnection = new SqlConnection(ConfigurationManager.ConnectionStrings[\学生成绩智能管理系统ConnectionString\

mysqlcommand = mysqlconnection.CreateCommand(); }

protected void Button1_Click(object sender, EventArgs e) {

mysqlcommand.CommandText

=

\

*

from

学

生

表

where

\

DropDownList1.SelectedValue+\ myadapter = new SqlDataAdapter();

myadapter.SelectCommand = mysqlcommand; myDataSet = new DataSet(); mysqlconnection.Open();

int numberOfRow = myadapter.Fill(myDataSet, \学生表\

this.GridView1.DataSource = new DataView(myDataSet.Tables[\学生表\ this.GridView1.DataBind();

Label1.Text = \共有\名符合条件学生\

17

}

学生信息修改过程 public string sqlconn; DataRow dtr;

SqlDataAdapter myadapter; SqlCommandBuilder scb; DataSet myDataSet;

SqlConnection mysqlconnection; int returnValue; DataTable tb; int numberOfRow;

protected void Page_Load(object sender, EventArgs e) {

mysqlconnection = new SqlConnection(ConfigurationManager.ConnectionStrings[\学生成绩智能管理系统ConnectionString\

SqlCommand mysqlcommand = mysqlconnection.CreateCommand();

mysqlcommand.CommandText = \学生表 where 学号=\\

myadapter = new SqlDataAdapter();

myadapter.SelectCommand = mysqlcommand; myDataSet = new DataSet(); mysqlconnection.Open();

numberOfRow = myadapter.Fill(myDataSet, \学生表\ mysqlconnection.Close(); tb = myDataSet.Tables[\学生表\ Button2.Enabled = false; Button3.Enabled = false; }

18

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