private void FrmSvrInfor_DoubleClick(object sender, System.EventArgs e) { OleDbConnection cnDB = default(OleDbConnection); OleDbCommand cmSQL = default(OleDbCommand); OleDbDataReader drSQL = default(OleDbDataReader); string StrPwd = null; StrPwd = Interaction.InputBox("Enter Password", "Authentication"); if (string.IsNullOrEmpty(StrPwd)) { return; } try { cnDB = new OleDbConnection(MSAccessCn); cnDB.Open(); cmSQL = new OleDbCommand("SELECT * FROM SvrParam", cnDB); drSQL = cmSQL.ExecuteReader(); if (drSQL.HasRows == false) { Interaction.MsgBox("Invalid Configuration Parameter" + Strings.Chr(13) + "System Halted", MsgBoxStyle.Information); System.Environment.Exit(0); } if (drSQL.Read) { if (drSQL.Item("AdminPwd") == StrPwd | drSQL.Item("ControlPwd") == StrPwd) { GrpAdvance.Enabled = true; this.Width = 507; } } drSQL.Close(); cnDB.Close(); cmSQL.Dispose(); cnDB.Dispose(); } catch (Exception er) { Interaction.MsgBox(er.Message, MsgBoxStyle.Critical, strApptitle); } }
private void FrmSvrInfor_Load(System.Object sender, System.EventArgs e) { LoadUserTheme(this); PanFooter.BackColor = HeaderTheme; OleDbConnection cnDB = default(OleDbConnection); OleDbCommand cmSQL = default(OleDbCommand); OleDbDataReader drSQL = default(OleDbDataReader); this.Text = "Server Information"; this.Width = 277; try { cnDB = new OleDbConnection(MSAccessCn); cnDB.Open(); cmSQL = new OleDbCommand("SELECT * FROM SvrParam", cnDB); drSQL = cmSQL.ExecuteReader(); if (drSQL.HasRows == false) { Interaction.MsgBox("Invalid Configuration Parameter" + Strings.Chr(13) + "System Halted", MsgBoxStyle.Information); System.Environment.Exit(0); } if (drSQL.Read) { cboServerName.Text = ChkNull(drSQL.Item("ServerName")); txtUserID.Text = ChkNull(drSQL.Item("UserID")); txtPassword.Text = ChkNull(drSQL.Item("Password")); txtAttachName.Text = ChkNull(drSQL.Item("AttachName")); chkWinAuthen.Checked = drSQL.Item("IntegratedSecurity"); txtOwner.Text = ChkNull(drSQL.Item("Owner")); } drSQL.Close(); cmSQL.Dispose(); cnDB.Close(); cnDB.Dispose(); // LoadServer() // AttachDetails() chkWinAuthen_CheckedChanged(sender, e); } catch (Exception er) { Interaction.MsgBox(er.Message, MsgBoxStyle.Critical, strApptitle); } }