//获取表“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); }