在数据库中使用asp.net C#计算测验分数

// 建立与数据库的连接
string connectionString = "YourConnectionString";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

// 查询题目和答案
string query = "SELECT Question, Answer FROM Quiz";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();

// 存储题目和答案的字典
Dictionary<string, string> quizData = new Dictionary<string, string>();

// 读取题目和答案，并存储到字典中
while (reader.Read())
{
    string question = reader["Question"].ToString();
    string answer = reader["Answer"].ToString();
    quizData.Add(question, answer);
}

// 关闭数据库连接
reader.Close();
connection.Close();

// 获取学生答案（假设通过表单提交）
string studentAnswer1 = Request.Form["answer1"];
string studentAnswer2 = Request.Form["answer2"];
// ...

// 计算分数
int score = 0;
if (quizData.ContainsKey("Question1") && quizData["Question1"] == studentAnswer1)
{
    score += 10; // 假设每道题目的分数为10分
}
if (quizData.ContainsKey("Question2") && quizData["Question2"] == studentAnswer2)
{
    score += 10;
}
// ...

// 存储分数
string studentId = "12345"; // 学生ID，假设为12345
string updateQuery = "UPDATE Students SET Score = @Score WHERE StudentId = @StudentId";
SqlCommand updateCommand = new SqlCommand(updateQuery, connection);
updateCommand.Parameters.AddWithValue("@Score", score);
updateCommand.Parameters.AddWithValue("@StudentId", studentId);
updateCommand.ExecuteNonQuery();

// 关闭数据库连接
connection.Close();