赛事管理系统(3)

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 = \管理员密码错误！\

} ｝

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库赛事管理系统(3)在线全文阅读。