private void cmbDataBases_Click(object sender, System.EventArgs e) { DataBaseServer wDataBaseServer = null; try { wDataBaseServer = new DataBaseServer(true); if (WindowsAutentificaction.Checked) { if (txtServer.Text.Trim() == String.Empty) { return; } } else { if (txtServer.Text.Trim() == String.Empty || txtUserName.Text.Trim() == String.Empty) { return; } } if (ComboDataBasesLoad == false) { if (DataBaseServer.TestConnection(txtServer.Text.Trim(), txtUserName.Text.Trim(), txtPassword.Text.Trim(), WindowsAutentificaction.Checked)) { cmbDataBases.Items.Clear(); if (wDataBaseServer.CnnString == null) { wDataBaseServer.CreateConnection(); } wDataBaseServer.CnnString.DataSource = txtServer.Text.Trim(); wDataBaseServer.CnnString.User = txtUserName.Text.Trim(); wDataBaseServer.CnnString.Password = txtPassword.Text.Trim(); wDataBaseServer.CnnString.WindowsAutentification = WindowsAutentificaction.Checked; DataTable dttDataBases = wDataBaseServer.GetDataBases(); foreach (DataRow dtr in dttDataBases.Rows) { cmbDataBases.Items.Add(dtr["DATABASE_NAME"].ToString()); } ComboDataBasesLoad = true; } else { MessageBox.Show("Los parametros de conexion no son validos.- Verifique nombre de usuario y contraseña", "Error de conección"); ConnectionOK = false; } } } catch (DataBaseExeption wDataBaseExeption) { txtServer.Text = wDataBaseExeption.CnnString.DataSource; txtUserName.Text = wDataBaseExeption.CnnString.User; txtPassword.Text = wDataBaseExeption.CnnString.Password; txtPassword.Focus(); WindowsAutentificaction.Checked = wDataBaseExeption.CnnString.WindowsAutentification; cmbDataBases.Items.Add(wDataBaseExeption.CnnString.InitialCatalog); cmbDataBases.Text = wDataBaseExeption.CnnString.InitialCatalog; MessageBox.Show(wDataBaseExeption.Message, "Error de conección"); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error de conección"); } }
private void cmbDataBases_Click(object sender, System.EventArgs e) { DataBaseServer wDataBaseServer = null; try { wDataBaseServer = new DataBaseServer(true); if (WindowsAutentificaction.Checked) { if (txtServer.Text.Trim() == String.Empty) return; } else { if (txtServer.Text.Trim() == String.Empty || txtUserName.Text.Trim() == String.Empty) return; } if (ComboDataBasesLoad == false) { if (DataBaseServer.TestConnection(txtServer.Text.Trim(), txtUserName.Text.Trim(), txtPassword.Text.Trim(), WindowsAutentificaction.Checked)) { cmbDataBases.Items.Clear(); if (wDataBaseServer.CnnString == null) { wDataBaseServer.CreateConnection(); } wDataBaseServer.CnnString.DataSource = txtServer.Text.Trim(); wDataBaseServer.CnnString.User = txtUserName.Text.Trim(); wDataBaseServer.CnnString.Password = txtPassword.Text.Trim(); wDataBaseServer.CnnString.WindowsAutentification = WindowsAutentificaction.Checked; DataTable dttDataBases = wDataBaseServer.GetDataBases(); foreach (DataRow dtr in dttDataBases.Rows) { cmbDataBases.Items.Add(dtr["DATABASE_NAME"].ToString()); } ComboDataBasesLoad = true; } else { MessageBox.Show("Los parametros de conexion no son validos.- Verifique nombre de usuario y contraseña", "Error de conección"); ConnectionOK = false; } } } catch (DataBaseExeption wDataBaseExeption) { txtServer.Text = wDataBaseExeption.CnnString.DataSource; txtUserName.Text = wDataBaseExeption.CnnString.User; txtPassword.Text = wDataBaseExeption.CnnString.Password; txtPassword.Focus(); WindowsAutentificaction.Checked = wDataBaseExeption.CnnString.WindowsAutentification; cmbDataBases.Items.Add(wDataBaseExeption.CnnString.InitialCatalog); cmbDataBases.Text = wDataBaseExeption.CnnString.InitialCatalog; MessageBox.Show(wDataBaseExeption.Message, "Error de conección"); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error de conección"); } }