c# - 将更多表列添加到列表框显示查询

Question

所以我有一个包含以下代码的辅助类:

public static DataSet selectStudent()
{
    MySqlConnection conn = connection();
    conn.Open();
    MySqlCommand cmd = new MySqlCommand();
    cmd.Connection = conn;
    MySqlDataAdapter adap = new MySqlDataAdapter(@"SELECT * FROM student", conn);
    MySqlCommandBuilder sqlCmd = new MySqlCommandBuilder(adap);
    DataSet sqlSet = new DataSet();
    adap.Fill (sqlSet, "studentInfo");
    conn.Close();
    return sqlSet;
}

在我的表单中，我有一个按钮来显示学生数据，这是代码:

private void btnStudentView_Click(object sender, EventArgs e)
{
    DataSet ds = studentHelperClass.selectStudent();
    lsbBoxStudent.DataSource = ds.Tables["studentInfo"];
    lsbBoxStudent.DisplayMember = "studentNumber";
}

但是，这仅显示表格的 studentNumber 行，我需要它来显示这些 majorField 和 gradePointAverage。

我该如何去做呢？

Answer 1

将 DataGridView 添加到表单并将其命名为 DataGridView1，然后

private void btnStudentView_Click(object sender, EventArgs e)
{
    DataSet ds = studentHelperClass.selectStudent();
    DataGridView1.DataSource = ds.Tables["studentInfo"];

}