public US_HT_BACKUP_HISTORY(decimal i_dbID)
 {
     pm_objDS = new DS_HT_BACKUP_HISTORY();
     pm_strTableName = c_TableName;
     IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
     v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
     SqlCommand v_cmdSQL;
     v_cmdSQL = v_objMkCmd.getSelectCmd();
     this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
     pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
 }
        public US_HT_BACKUP_HISTORY(decimal i_dbID)
        {
            pm_objDS        = new DS_HT_BACKUP_HISTORY();
            pm_strTableName = c_TableName;
            IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);

            v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
            SqlCommand v_cmdSQL;

            v_cmdSQL = v_objMkCmd.getSelectCmd();
            this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
            pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
        }
 public US_HT_BACKUP_HISTORY()
 {
     pm_objDS = new DS_HT_BACKUP_HISTORY();
     pm_strTableName = c_TableName;
     pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
 }
 public US_HT_BACKUP_HISTORY()
 {
     pm_objDS        = new DS_HT_BACKUP_HISTORY();
     pm_strTableName = c_TableName;
     pm_objDR        = pm_objDS.Tables[pm_strTableName].NewRow();
 }
 //private void CreateLogin (string sqlLoginName, string sqlLoginPassword, string databaseName)
 //{
 //    Server myServer = GetServer();
 //    Login newLogin = myServer.Logins[sqlLoginName];
 //    if(newLogin != null)
 //        newLogin.Drop();
 //    newLogin = new Login(myServer, sqlLoginName);
 //    newLogin.PasswordPolicyEnforced = false;
 //    newLogin.LoginType = LoginType.SqlLogin;
 //    newLogin.Create(sqlLoginPassword);
 //    //Create DatabaseUser
 //    DatabaseMapping mapping =
 //        new DatabaseMapping(newLogin.Name, MainDbName, newLogin.Name);
 //    Database currentDb = myServer.Databases[databaseName];
 //    User dbUser = new User(currentDb, newLogin.Name);
 //    dbUser.Login = sqlLogin;
 //    dbUser.Create();
 //    dbUser.AddToRole("db_owner");
 //}
 private void load_data_to_grid()
 {
     US_HT_BACKUP_HISTORY v_us = new US_HT_BACKUP_HISTORY();
     DS_HT_BACKUP_HISTORY v_ds = new DS_HT_BACKUP_HISTORY();
     v_us.FillDataset(v_ds);
     gridControl1.DataSource = v_ds.Tables[0];
 }