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