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(); }
//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]; }