public static clsListStudent getAllStudent()
{
clsListStudent allClients = new clsListStudent();
OleDbConnection mycon = new OleDbConnection();
mycon.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Ravi patel\source\repos\PrjWinCsExam\PrjWinCsExam\Database\College.accdb";
mycon.Open();
OleDbCommand mycmd = new OleDbCommand();
mycmd.CommandText = "SELECT SNumber, SName, SBirthdate, SAverage FROM Students";
mycmd.Connection = mycon;
OleDbDataReader myRder = mycmd.ExecuteReader();
while (myRder.Read())
{
string num = myRder["SNumber"].ToString();
string name = myRder["SName"].ToString();
string date = myRder["SBirthdate"].ToString();
string avg = myRder["SAverage"].ToString();
clsStudent aStudent = new clsStudent(num, name, date, Single.Parse(avg));
allClients.Add(aStudent);
}
return(allClients);
}
public void Edit(int position, clsStudent student)
{
studentList[position] = student;
}
public void Add(clsStudent student)
{
this.studentList.Add(student);
}