public static DataSet ExecuteDataset(string Username, string Password)
        {
            _sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
              SqlParameter[] param = new SqlParameter[2];
              SqlParameter p1 = new SqlParameter(PARAM1NAME,Username);
              SqlParameter p2 = new SqlParameter(PARAM2NAME,Password);
             param[0] = p1;
             param[1] = p2;

              return _sqlHelper.ExecuteDataset(PROCEDURE_NAME, param);
        }
예제 #2
0
        public static DataSet ExecuteDataset(string Username, string Password)
        {
            _sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
            SqlParameter[] param = new SqlParameter[2];
            SqlParameter   p1    = new SqlParameter(PARAM1NAME, Username);
            SqlParameter   p2    = new SqlParameter(PARAM2NAME, Password);

            param[0] = p1;
            param[1] = p2;

            return(_sqlHelper.ExecuteDataset(PROCEDURE_NAME, param));
        }
 private spGetLeaveByEmployeeID()
 {
     _sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
 }
예제 #4
0
 private spCheckLogin()
 {
     _sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
 }
 private spCheckLogin()
 {
     _sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
 }
예제 #6
0
 private spGetLeaveByEmployeeID()
 {
     _sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
 }
예제 #7
0
 private spGetEmployeeDetails()
 {
     _sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
 }
 private spGetEmployeeDetailsByID()
 {
     _sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
 }