if (!IsPostBack)
{
DisplayStudentInfo(Request.QueryString["学号"]); ; // 如果未登录,重定向到登录页
}
private void DisplayStudentInfo(string 学号)
{
string connectionString = "Data Source=localhost;Initial Catalog=奖学金评定系统;Integrated Security=True"; // 连接字符串
string query = "SELECT * FROM Student WHERE 学号 = @StudentID";
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@StudentID", 学号);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Label1.Text = "学号: " + reader["学号"].ToString();
Label2.Text = "姓名: " + reader["姓名"].ToString();
Label3.Text = "性别: " + reader["性别"].ToString();
Label4.Text = "学院: " + reader["学院"].ToString();
Label5.Text = "成绩: " + reader["成绩"].ToString();
Label6.Text = "辅导员: " + reader["辅导员"].ToString();
Label7.Text = "身份证号: " + reader["身份证号"].ToString();
}
else
{
// 如果没有找到学生,显示错误信息或者重定向到错误页面
Response.Write("未找到该学生信息。");
}
}
}
}
可以帮我看看我的代码该怎么改吗