private void cmdReadFromConnString_Click(object sender, EventArgs e) { try { GenericOLEDBDAL dal = new GenericOLEDBDAL(); dal.ConnectionString = txtConnectionString.Text; txtDataSource.Text = dal.DataSource; SetProviderFromText(dal.Provider); txtUserName.Text = dal.UserName; txtPassword.Text = dal.Password; txtServer.Text = dal.Server; txtDatabase.Text = dal.Database; txtInitialCatalogue.Text = dal.InitialCatalogue; chkPersistSecurityInfo.Checked = dal.PersistSecurityInfo; chkTrustedConnection.CheckState = (CheckState)dal.TrustedConnection; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cmdConstructConnString_Click(object sender, EventArgs e) { try { GenericOLEDBDAL dal = new GenericOLEDBDAL(); dal.DataSource = txtDataSource.Text; dal.Provider = GetProviderFromCombo(); dal.UserName = txtUserName.Text; dal.Password = txtPassword.Text; dal.InitialCatalogue = txtInitialCatalogue.Text; dal.Server = txtServer.Text; dal.Database = txtDatabase.Text; dal.PersistSecurityInfo = chkPersistSecurityInfo.Checked; dal.TrustedConnection = (byte)chkTrustedConnection.CheckState; txtConnectionString.Text = dal.GetConnectionString(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }