private void btnTestConnection_Click(object sender, EventArgs e) { strServer = txtServerName.Text.Trim(); strDatabase = txtDatabaseName.Text.Trim(); strUser = txtUserName.Text.Trim(); strPassword = txtPassword.Text.Trim(); if (strServer == "" || strDatabase == "" || strUser == "") { MessageBox.Show(this, "Test Connection string failed!", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { try { EzSqlCollection.EzSql2 ezsql2 = new EzSqlCollection.EzSql2(strServer, strDatabase, strUser, strPassword); ezsql2.open(); ezsql2.close(); MessageBox.Show(this, "Test Connection string successfully!", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch { MessageBox.Show(this, "Test Connection string failed!", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public BaseForm() { InitializeComponent(); if (HPA.Common.StaticVars.ServerName == null) return; DBEngine = new EzSqlCollection.EzSql2(HPA.Common.StaticVars.ServerName, HPA.Common.StaticVars.DatabaseName, HPA.Common.StaticVars.UserID_sql, HPA.Common.StaticVars.Password); DBEngine.open(); }
public BaseForm() { InitializeComponent(); if (HPA.Common.StaticVars.ServerName == null) { return; } DBEngine = new EzSqlCollection.EzSql2(HPA.Common.StaticVars.ServerName, HPA.Common.StaticVars.DatabaseName, HPA.Common.StaticVars.UserID_sql, HPA.Common.StaticVars.Password); DBEngine.open(); }
public BaseUserControl() { InitializeComponent(); if (this.DesignMode) { return; } if (HPA.Common.StaticVars.ServerName == null) { return; } try { DBEngine = new EzSqlCollection.EzSql2(HPA.Common.StaticVars.ServerName, HPA.Common.StaticVars.DatabaseName, HPA.Common.StaticVars.UserID_sql, HPA.Common.StaticVars.Password); DBEngine.open(); } catch { //throw new Exception("Can not connect to server"); if (MessageBox.Show("Ket noi lai ko?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes) { DBEngine = new EzSqlCollection.EzSql2(HPA.Common.StaticVars.ServerName, HPA.Common.StaticVars.DatabaseName, HPA.Common.StaticVars.UserID_sql, HPA.Common.StaticVars.Password); DBEngine.open(); MessageBox.Show("ket noi thanh cong"); } } if (StaticVars.FullClassName.Equals(string.Empty)) { return; } object objRight = DBEngine.execReturnValue("SC_USEROBJECTRIGHT_GET", "@p_FullClassName", StaticVars.FullClassName, "@p_LoginID", StaticVars.LoginID); if ((objRight == DBNull.Value) || (Convert.ToInt32(objRight) == 0)) { Methods.ShowMessage(CommonConst.NO_RIGHT_TO_ACCESS); return; } else { _UserRight = objRight; } }
private void btnSave_Click(object sender, EventArgs e) { StaticVars.ConnectionString = String.Format("Server = {0}{1}Database = {2}{1}UID = {3}{1}PWD = {4}", txtServerName.Text.Trim(), SEMICOLON_CHAR, txtDatabaseName.Text.Trim(), txtUserName.Text.Trim(), txtPassword.Text.Trim()); try { EzSqlCollection.EzSql2 ezsql2 = new EzSqlCollection.EzSql2(txtServerName.Text.Trim(), txtDatabaseName.Text.Trim(), txtUserName.Text.Trim(), txtPassword.Text.Trim()); ezsql2.open(); ezsql2.close(); Methods.WriteFile(Encryption.EncryptText(StaticVars.ConnectionString, true)); MessageBox.Show(this, "Connection setting has saved successfully. Changes will be applied for the next log on.", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch { MessageBox.Show(this, "Connection setting can not saved. Please re-install Paradise if you can.", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Error); } isNewConnection = false; }
private void btnClose_Click(object sender, EventArgs e) { if (!isNewConnection) { try { EzSqlCollection.EzSql2 ezsql2 = new EzSqlCollection.EzSql2(txtServerName.Text.Trim(), txtDatabaseName.Text.Trim(), txtUserName.Text.Trim(), txtPassword.Text.Trim()); ezsql2.open(); ezsql2.close(); Application.Restart(); } catch { MessageBox.Show(this, "Connection setting is not available.", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else Application.Exit(); }
private void btnClose_Click(object sender, EventArgs e) { if (!isNewConnection) { try { EzSqlCollection.EzSql2 ezsql2 = new EzSqlCollection.EzSql2(txtServerName.Text.Trim(), txtDatabaseName.Text.Trim(), txtUserName.Text.Trim(), txtPassword.Text.Trim()); ezsql2.open(); ezsql2.close(); Application.Restart(); } catch { MessageBox.Show(this, "Connection setting is not available.", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { Application.Exit(); } }
public SaveData(string scrName, EzSqlCollection.EzSql2 DBE) { DBEngine = DBE; screenName = scrName; }