我想从SqlDatabase读取数据,但是遇到了IndexOutOfRangeException的错误,这里是我的表的截图:
所以这里有一个函数,它从数据库获取数据并将其存储在Lesson类的列表中,我在lessons.Add()中遇到了异常:
public List<Lesson> GetLessonsFromDay(string Day)
{
command.CommandText = "SELECT * FROM [Scadule] WHERE [day]='" + Day + "'";
con.Open();
SqlDataReader sdr = command.ExecuteReader();
List<Lesson> lessons = new List<Lesson>();
while (sdr.Read())
{
lessons.Add(new Lesson(Day, (int)sdr["[num]"], (string)sdr["[time]"],(string)sdr["[class]"],(string)sdr["[where]"]));
}
con.Close();
return lessons;
}
这是我的课程类:
public class Lesson
{
public Lesson(string Day, int Num, string Time, string Class, string Where)
{
this.Day = Day;
this.Num = Num;
this.Time = Time;
this.Class = Class;
this.Where = Where;
}
public string Day { get; set; }
public int Num { get; set; }
public string Time { get; set; }
public string Class { get; set; }
public string Where { get; set; }
}
[]
来获取索引值? 尝试使用(int)sdr["num"],
代替。 - bash.d