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