//获取表“Subjects”中的所有数据
public DataTable getSubjectDataTable()
{
DataTable dt = new DataTable("Subjects");
using (SqlConnection con = new SqlConnection(Dbhelper.dbsr))
{
Dbhelper helper = new Dbhelper(con);
SqlDataAdapter adapter = helper.GetAdapter("select * from Subjects order by sSubject");
}
return(dt);
}
public DataTable getStudentDataTable()
{
DataTable dt = new DataTable("Students");
using (SqlConnection con = new SqlConnection(Dbhelper.dbsr))
{
Dbhelper DB = new Dbhelper(con);
SqlDataAdapter adapter = DB.GetAdapter("select*from Students order by sNo");
adapter.Fill(dt);
con.Close();
}
return(dt);
}
