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);
}
}
