Esempio n. 1
0
      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;
          }

      }
Esempio n. 2
0
      public DataTable GetClasses()
      {
          using (DbAccess db = new DbAccess())
          {
              DataTable dt = db.ExecuteDataTable("select * from Class");
              return dt;
          }

      }
Esempio n. 3
0
     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;
            }

        }
Esempio n. 4
0
 public DataTable GetList()
 {
     DbAccess db = new DbAccess();
     return db.ExecuteDataTable("Org_List");
 }