SqlCommand mysqlcommand = mysqlconnection.CreateCommand();
mysqlcommand.CommandText = \用户名,密码,备注 from 用户表 where 用户名=\+ \
myadapter = new SqlDataAdapter();
myadapter.SelectCommand = mysqlcommand; myDataSet = new DataSet(); mysqlconnection.Open();
int numberOfRow = myadapter.Fill(myDataSet, \用户表\ mysqlconnection.Close();
DataTable tb = myDataSet.Tables[\用户表\ dtr = tb.Rows[0]; }
protected void Button1_Click(object sender, EventArgs e) {
TextBox1.ReadOnly = false; TextBox4.Visible = true; TextBox4.ReadOnly = false; TextBox1.Text = \ TextBox2.Text = \ TextBox2.ReadOnly = false;
TextBox3.Text = \请记住新的密码以免造成不必要的麻烦!\ Label1.Text = \原始密码\ Label2.Text = \新密码\ Label3.Text = \小提示\ Label4.Visible = true; Button4.Visible = true; Button5.Visible = true; Button5.Text = \取消\ }
9
protected void Button4_Click(object sender, EventArgs e) {
SqlCommand coutsqlcommand = mysqlconnection.CreateCommand(); mysqlconnection.Open();
if (TextBox1.Text != \ {
if (TextBox4.Visible == true) {
coutsqlcommand.CommandText = \count(*) as 数目 from 用户表 where 用户名=\密码=\ returnValue = (Int32)coutsqlcommand.ExecuteScalar(); if (returnValue == 1) {
if (TextBox2.Text == TextBox4.Text) {
Response.Write(\密码修改成功！');\ scb = new SqlCommandBuilder(myadapter);
myDataSet.Tables[\用户表\密码\ myadapter.Update(myDataSet.Tables[\用户表\ } else
Response.Write(\密码重复确认错误！');\ } else
Response.Write(\密码错误！');\ } else
if (TextBox4.Visible != true) {
10
if (Label1.Text == \用户名\ {
myDataSet.Tables[\用户表\备注\ scb = new SqlCommandBuilder(myadapter); myadapter.Update(myDataSet.Tables[\用户表\
Response.Write(\备注修改成功！');\ }
if (Label1.Text == \新用户名\ {
coutsqlcommand.CommandText = \count(*) as 数目 from 用户表 where 用户名=\
returnValue = (int)coutsqlcommand.ExecuteScalar(); if (returnValue != 0) {
Response.Write(\用户名已存在！');\ } else {
DataRow dbr = myDataSet.Tables[\用户表\ dbr[\用户名\ dbr[\密码\ dbr[\备注\ myDataSet.Tables[\用户表\ scb = new SqlCommandBuilder(myadapter); myadapter.Update(myDataSet.Tables[\用户表\
Response.Write(\添加用户成功！');\ } }
if (Label1.Text == \删除用户\
11
{
coutsqlcommand.CommandText = \count(*) as 数目 from 用户表 where 用户名=\+ \+ Convert.ToString(TextBox1.Text) + \+ \and 密码=\+ \+ Convert.ToString(TextBox2.Text) + \
returnValue = (int)coutsqlcommand.ExecuteScalar(); if (returnValue == 1) {
Response.Write(\输入正确,可以删除');\ Button5.Enabled = true; Button4.Enabled = false; } else {
Response.Write(\密码或用户名错误！');\ Button5.Enabled = false; } } } } else
Response.Write(\请完善信息！');\ mysqlconnection.Close(); }
protected void Button6_Click(object sender, EventArgs e) {
TextBox1.Text = (String)(dtr[\用户名\ TextBox2.Text = \ TextBox3.Text = (String)(dtr[\备注\ Label1.Text = \用户名\
12
Label2.Text = \密码\ Label3.Text = \备注\ Label4.Visible = false; TextBox4.Visible = false; Button4.Visible = false; Button5.Visible = false; }
protected void Button2_Click(object sender, EventArgs e) {
Button4.Visible = true; Button5.Visible = false; TextBox4.Visible = false; TextBox3.ReadOnly = false; Label1.Text = \用户名\ Label2.Text = \密码\ Label3.Text = \备注\ Label4.Visible = false;
TextBox1.Text = (String)(dtr[\用户名\ TextBox2.Text = \ TextBox3.Text = (String)(dtr[\备注\ }
protected void Button3_Click(object sender, EventArgs e) {
Button4.Visible = true; Button5.Visible = false; Button4.Enabled = true; Button5.Enabled = true; TextBox4.Visible = false; TextBox1.ReadOnly = false;
13