conn.Close();
SqlCommand cmdxmc = new SqlCommand(); cmdxmc.Connection = conn;
cmdxmc.CommandText = \+ \
conn.Open();
Textxmc.Text = cmdxmc.ExecuteScalar().ToString(); conn.Close();
Label3.Visible = true; Lbxx.Text = \ }
}
}
protected void Btxg_Click(object sender, EventArgs e) {
SqlConnection conn = new SqlConnection(); conn.ConnectionString =
ConfigurationManager.ConnectionStrings[\
SqlCommand cmdjy = new SqlCommand(); cmdjy.Connection = conn;
cmdjy.CommandText = \Application[\
SqlParameter spjy = new SqlParameter(\ spjy.Direction = ParameterDirection.Input; conn.Open();
spjy.Value = cmdjy.ExecuteScalar().ToString(); conn.Close();
if (Txjy.Text == spjy.Value.ToString()) {
if (Label3.Visible == true) {
SqlCommand cmdxm = new SqlCommand(); cmdxm.Connection = conn;
cmdxm.CommandText = \\
conn.Open();
cmdxm.ExecuteScalar(); conn.Close();
SqlCommand cmdxma = new SqlCommand(); cmdxma.Connection = conn;
cmdxma.CommandText = \cansai set Xma='\+ Textxma.Text + \where Xh='\
conn.Open();
cmdxma.ExecuteScalar(); conn.Close();
SqlCommand cmdxmb = new SqlCommand(); cmdxmb.Connection = conn;
cmdxmb.CommandText = \cansai set Xmb='\+ Textxmb.Text + \where Xh='\
conn.Open();
cmdxmb.ExecuteScalar(); conn.Close();
SqlCommand cmdxmc = new SqlCommand(); cmdxmc.Connection = conn;
cmdxmc.CommandText = \cansai set Xmc='\+ Textxmc.Text + \where Xh='\
conn.Open();
cmdxmc.ExecuteScalar(); conn.Close();
Lbxx.Text = \你个禽兽,修改成功!\ } else {
Lbxx.Text = \请先查询您需要修改的学号!\ }
} else {
Lbxx.Text = \密码错误!\
}
}
protected void Btsc_Click(object sender, EventArgs e) {
SqlConnection conn = new SqlConnection(); conn.ConnectionString =
ConfigurationManager.ConnectionStrings[\
SqlCommand cmdjy = new SqlCommand(); cmdjy.Connection = conn;
cmdjy.CommandText = \Application[\
SqlParameter spjy = new SqlParameter(\ spjy.Direction = ParameterDirection.Input; conn.Open();
spjy.Value = cmdjy.ExecuteScalar().ToString(); conn.Close();
if (Txjy.Text == spjy.Value.ToString()) {
SqlCommand cmdsc = new SqlCommand(); cmdsc.Connection = conn;
cmdsc.CommandText = \cansai where Xh='\+ TextBox1.Text + \
conn.Open();
cmdsc.ExecuteScalar(); conn.Close();
Lbxx.Text = \删除成功!\ lbxh.Text = \ Textxm.Text = \ Textxma.Text = \ Textxmb.Text = \ Textxmc.Text = \
Label3.Visible = false;
} else {
Lbxx.Text = \管理员密码错误!\
} }