public main(login my_login) { InitializeComponent(); writetimu(i, i + 1, i + 2, i + 3, i + 4, i + 5); label2.Text = "1"; this.mylogin = my_login; xuehao = mylogin.getxuehao(); SqlConnection conn1 = new SqlConnection(_connectionString); conn1.Open(); string strSqlq1 = "select * from student where 学号 = '" + xuehao + "'"; SqlCommand cmd1 = new SqlCommand(strSqlq1, conn1); SqlDataReader dr1 = cmd1.ExecuteReader(); if (dr1.Read()) { xingming.Text = dr1["姓名"].ToString(); } dr1.Close(); cmd1.ExecuteNonQuery(); String deletescore = "delete from score"; SqlCommand cmd2 = new SqlCommand(deletescore, conn1); SqlDataReader dr2 = cmd2.ExecuteReader(); dr2.Close(); cmd2.ExecuteNonQuery(); }
public main(login my_login) { InitializeComponent(); this.mylogin = my_login; xuehao = mylogin.getxuehao(); SqlConnection conn1 = new SqlConnection(); conn1.ConnectionString = @"Server = localhost;Database=CLASSTEST;integrated security=true"; conn1.Open(); string strSqlq1 = "select * from student where 学号 = '" + xuehao + "'"; SqlCommand cmd1 = new SqlCommand(strSqlq1, conn1); SqlDataReader dr1 = cmd1.ExecuteReader(); if (dr1.Read()) { xingming.Text = dr1["姓名"].ToString(); } }