public DataTable GetRoles() // Get all the user's roll from roll Table { using (DbAccess db = new DbAccess()) { DataTable dt = db.ExecuteDataTable("select * from Role"); return dt; } }
public DataTable GetClasses() { using (DbAccess db = new DbAccess()) { DataTable dt = db.ExecuteDataTable("select * from Class"); return dt; } }
public DataTable TotrecpNos(int adno) { using (DbAccess db = new DbAccess()) { DataTable dt = db.ExecuteDataTable("select COUNT(ReceiptNo) trecpno from StudentFee where AdmNo='" + adno + "'"); //where UID='" + id + "' return dt; } }
public DataTable GetList() { DbAccess db = new DbAccess(); return db.ExecuteDataTable("Org_List"); }