c# - 从数据库中读取 ListBox SelectedItem 和 SELECT where id = value

Question

所以我想从列表框中读取所选项目并从数据库中选择，其中 id = value 来自列表框并将完整详细信息显示到消息框......但我找不到它我在抛出时出错有人可以帮忙吗我如何解决这个问题...

代码

public List<Students> FullDetails(Students student)
        {
            List<Students> studentList = new List<Students>();
            try
            {
                command.CommandText = "SELECT FROM Students WHERE ID = " + student.Id;

                command.CommandType = CommandType.Text;
                connection.Open();

                OleDbDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    Students s = new Students();
                    s.Id = Convert.ToInt32(reader["ID"].ToString());
                    s.Name = reader["Name"].ToString();
                    s.LName = reader["LName"].ToString();
                    s.FName = reader["FName"].ToString();
                    s.MName = reader["MName"].ToString();
                    s.Absences = reader["Absences"].ToString();
                    s.Degrees = reader["Degrees"].ToString();

                    studentList.Add(s);
                }
                return studentList;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if (connection != null)
                {
                    connection.Close();
                }
            }
        }

表单代码

Students s = new Students();
s = search_ls.SelectedItem as Students;
string fd = conn.FullDetails(s).ToString();
MessageBox.Show(fd);

Answer 1

您似乎错过了选择查询中的字段列表。我想你的意思是在 SELECT 和 FROM 之间加一个星号:

SELECT * FROM Students WHERE ID = ...