protected void Button1_Click(object sender, EventArgs e) {
if(numberOfRow!=0) {
dtr = tb.Rows[0]; Button2.Enabled = true; Button3.Enabled = true;
TextBox2.Text = Convert.ToString(dtr[\学号\ TextBox3.Text = Convert.ToString(dtr[\姓名\ TextBox4.Text = Convert.ToString(dtr[\性别\ TextBox5.Text = Convert.ToString(dtr[\院系\ TextBox6.Text = Convert.ToString(dtr[\出生日期\ TextBox7.Text = Convert.ToString(dtr[\家庭住址\ TextBox8.Text = Convert.ToString(dtr[\入学时间\ TextBox9.Text = Convert.ToString(dtr[\政治面貌\ TextBox10.Text = Convert.ToString(dtr[\备注\ } else {
Button2.Enabled = false; Button3.Enabled = false;
Response.Write(\该学生不存在');\ } }
protected void Button3_Click(object sender, EventArgs e) {
TextBox2.Text = \ TextBox3.Text = \ TextBox4.Text = \
19
TextBox5.Text = \ TextBox6.Text = \ TextBox7.Text = \ TextBox8.Text = \ TextBox9.Text = \ TextBox10.Text = \ }
protected void Button2_Click(object sender, EventArgs e) {
if(TextBox2.Text==\ {
Response.Write(\请完善信息!');\ } else {
dtr = tb.Rows[0];
dtr[\学号\ dtr[\姓名\ dtr[\性别\ dtr[\院系\ dtr[\出生日期\ dtr[\家庭住址\ dtr[\入学时间\ dtr[\政治面貌\ dtr[\备注\
SqlCommandBuilder scb = new SqlCommandBuilder(myadapter); myadapter.Update(myDataSet.Tables[\学生表\
Response.Write(\信息修改成功！');\
20
} } 学生信息删除 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;
21
}
protected void Button1_Click(object sender, EventArgs e) {
if (numberOfRow != 0) {
dtr = tb.Rows[0]; Button2.Enabled = true; Button3.Enabled = false;
TextBox2.Text = Convert.ToString(dtr[\学号\ TextBox3.Text = Convert.ToString(dtr[\姓名\ TextBox4.Text = Convert.ToString(dtr[\性别\ TextBox5.Text = Convert.ToString(dtr[\院系\ TextBox6.Text = Convert.ToString(dtr[\出生日期\ TextBox7.Text = Convert.ToString(dtr[\家庭住址\ TextBox8.Text = Convert.ToString(dtr[\入学时间\ TextBox9.Text = Convert.ToString(dtr[\政治面貌\ TextBox10.Text = Convert.ToString(dtr[\备注\ } else {
Button2.Enabled = false; Button3.Enabled = false;
Response.Write(\该学生不存在');\ } }
protected void Button2_Click(object sender, EventArgs e) {
Button2.Enabled = false; Button3.Enabled = true;
22
}
protected void Button3_Click(object sender, EventArgs e) {
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(\未知错误！');\ }
Button3.Enabled = false; Button2.Enabled = false; } }
学生信息插入 public string sqlconn; DataRow dtr;
SqlDataAdapter myadapter; SqlCommandBuilder scb; DataSet myDataSet;
SqlConnection mysqlconnection; int returnValue; DataTable tb;
23