private void SetUI(CnnString cnn) { WindowsAutentificaction.Checked = cnn.WindowsAutentification; cmbDataBases.Text = cnn.InitialCatalog; cmbServer.Text = cnn.DataSource; if (cnn.WindowsAutentification) { txtUserName.Text = string.Empty; txtPassword.Text = string.Empty; txtUserName.Enabled = false; txtPassword.Enabled = false; lblUserName.ForeColor = System.Drawing.Color.Black; lblPassword.ForeColor = System.Drawing.Color.Black; } else { txtUserName.Text = cnn.User; txtPassword.Text = cnn.Password; txtUserName.Enabled = true; txtPassword.Enabled = true; lblUserName.ForeColor = System.Drawing.Color.DimGray; lblPassword.ForeColor = System.Drawing.Color.DimGray; } if (string.IsNullOrEmpty(cnn.DataSource) || string.IsNullOrEmpty(cnn.InitialCatalog)) { return; } txtCnnString.Text = cnn.ToString(); }
/// <summary> /// Carga las bses de datos del server /// </summary> /// <param name="pCnnString"></param> void FillDatabaseCombo(CnnString pCnnString) { if (onInitServerCollection) { return; } SqlConnection sqlConnection = new SqlConnection(pCnnString.ToString()); ServerConnection serverConnection = new ServerConnection(sqlConnection); try { _Server = new Server(serverConnection); cmbDataBases.Items.Clear(); foreach (Database db in _Server.Databases) { cmbDataBases.Items.Add(db.Name); } cmbDataBases.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show(Fwk.CodeGenerator.HelperFunctions.GetAllMessageException(ex), Fwk.GuidPk.Properties.Resources.ProductTitle); } }
public bool Test() { _cnn = GetAuxiliarCnnString(); if (string.IsNullOrEmpty(_cnn.DataSource)) { MessageBox.Show("Ingrese servidor de SQL.-", Fwk.GuidPk.Properties.Resources.ProductTitle); cmbServer.Focus(); return(false); } if (string.IsNullOrEmpty(_cnn.InitialCatalog)) { MessageBox.Show("Seleccione o ingrese una base de datos.-", Fwk.GuidPk.Properties.Resources.ProductTitle); cmbDataBases.Focus(); return(false); } if (!_cnn.WindowsAutentification) { if (string.IsNullOrEmpty(_cnn.User)) { MessageBox.Show("Ingrese usuario.-", Fwk.GuidPk.Properties.Resources.ProductTitle); txtUserName.Focus(); return(false); } } SqlConnection sqlConnection = new SqlConnection(_cnn.ToString()); Microsoft.SqlServer.Management.Common.ServerConnection serverConnection = new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConnection); try { _Server = new Server(serverConnection); //_Server.Databases[_cnn.InitialCatalog].Tables.Refresh(); ////iterate over all Databases //foreach (Database db in _Server.Databases) //{ MessageBox.Show("Coneccion exitosa.- a " + _Server.Information.Product.ToString(), Fwk.GuidPk.Properties.Resources.ProductTitle); //} } catch (Exception ex) { MessageBox.Show(Fwk.CodeGenerator.HelperFunctions.GetAllMessageException(ex), Fwk.GuidPk.Properties.Resources.ProductTitle); return(false); } return(true); }
private void btnTestConnection_Click(object sender, EventArgs e) { _cnn = GetAuxiliarCnnString(); if (string.IsNullOrEmpty(_cnn.DataSource)) { MessageBox.Show("Ingrese servidor de SQL.-", "Fwk wizard"); cmbServer.Focus(); return; } if (string.IsNullOrEmpty(_cnn.InitialCatalog)) { MessageBox.Show("Seleccione o ingrese una base de datos.-", "Fwk wizard"); cmbDataBases.Focus(); return; } if (!_cnn.WindowsAutentification) { if (string.IsNullOrEmpty(_cnn.User)) { MessageBox.Show("Ingrese usuario.-", "Fwk wizard"); txtUserName.Focus(); return; } } SqlConnection sqlConnection = new SqlConnection(_cnn.ToString()); Microsoft.SqlServer.Management.Common.ServerConnection serverConnection = new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConnection); try { _Server = new Server(serverConnection); ////iterate over all Databases foreach (Database db in _Server.Databases) { MessageBox.Show("Coneccion exitosa.-", "Fwk wizard"); return; } } catch (Exception ex) { MessageBox.Show(HelperFunctions.GetAllMessageException(ex), "Fwk wizard"); } }
public void setIDictionaryService(CnnString cnn) { IDictionaryService dictionaryService = GetService(typeof(IDictionaryService)) as IDictionaryService; if (cnn == null) { dictionaryService.SetValue("ConnectionString", null); dictionaryService.SetValue("DatabaseName", null); } else { dictionaryService.SetValue("ConnectionString", cnn.ToString()); dictionaryService.SetValue("DatabaseName", cnn.InitialCatalog); } }
private void LoadTables(CnnString cnn) { SqlConnection sqlConnection = new SqlConnection(cnn.ToString()); ServerConnection serverConnection = new ServerConnection(sqlConnection); try { Server wServer = new Server(serverConnection); Database db = new Database(wServer, cnn.InitialCatalog); db.Views.Refresh(); _Views = db.Views; } catch (Exception ex) { MessageBox.Show(HelperFunctions.GetAllMessageException(ex)); } }
/// <summary> /// Carga las bses de datos del server /// </summary> /// <param name="pCnnString"></param> void FillDatabaseCombo(CnnString pCnnString) { if (onInitServerCollection) return; SqlConnection sqlConnection = new SqlConnection(pCnnString.ToString()); ServerConnection serverConnection = new ServerConnection(sqlConnection); try { _Server = new Server(serverConnection); cmbDataBases.Items.Clear(); foreach (Database db in _Server.Databases) { cmbDataBases.Items.Add(db.Name); } cmbDataBases.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show(HelperFunctions.GetAllMessageException(ex)); } }
private void LoadTables(CnnString cnn) { SqlConnection sqlConnection = new SqlConnection(cnn.ToString()); ServerConnection serverConnection = new ServerConnection(sqlConnection); try { Server wServer = new Server(serverConnection); Database db = new Database(wServer, cnn.InitialCatalog); db.Views.Refresh(); _Views = db.Views; } catch (Exception ex) { MessageBox.Show(HelperFunctions.GetAllMessageException(ex)); } }
/// <summary> /// /// </summary> /// <param name="pCnnString"></param> /// <returns></returns> public static bool TestConnection(CnnString pCnnString) { using (SqlConnection wCnn = new SqlConnection(pCnnString.ToString())) { try { wCnn.Open(); wCnn.Close(); return true; } catch (Exception ex) { throw new DataBaseExeption(ex, pCnnString); } } }
private void btnTestConnection_Click(object sender, EventArgs e) { _cnn = GetAuxiliarCnnString(); if (string.IsNullOrEmpty(_cnn.DataSource)) { MessageBox.Show("Ingrese servidor de SQL.-", "Fwk wizard"); cmbServer.Focus(); return; } if (string.IsNullOrEmpty(_cnn.InitialCatalog)) { MessageBox.Show("Seleccione o ingrese una base de datos.-","Fwk wizard"); cmbDataBases.Focus(); return; } if (!_cnn.WindowsAutentification) { if (string.IsNullOrEmpty(_cnn.User)) { MessageBox.Show("Ingrese usuario.-", "Fwk wizard"); txtUserName.Focus(); return; } } SqlConnection sqlConnection = new SqlConnection(_cnn.ToString()); Microsoft.SqlServer.Management.Common.ServerConnection serverConnection = new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConnection); try { _Server = new Server(serverConnection); ////iterate over all Databases foreach (Database db in _Server.Databases) { MessageBox.Show("Coneccion exitosa.-", "Fwk wizard"); return; } } catch (Exception ex) { MessageBox.Show(HelperFunctions.GetAllMessageException(ex), "Fwk wizard"); } }
public void setIDictionaryService(CnnString cnn) { IDictionaryService dictionaryService = GetService(typeof(IDictionaryService)) as IDictionaryService; if (cnn == null) { dictionaryService.SetValue("ConnectionString", null); dictionaryService.SetValue("DatabaseName", null); } else { dictionaryService.SetValue("ConnectionString", cnn.ToString()); dictionaryService.SetValue("DatabaseName", cnn.InitialCatalog); } }
public bool Test() { _cnn = GetAuxiliarCnnString(); if (string.IsNullOrEmpty(_cnn.DataSource)) { MessageBox.Show("Ingrese servidor de SQL.-", Fwk.GuidPk.Properties.Resources.ProductTitle); cmbServer.Focus(); return false; } if (string.IsNullOrEmpty(_cnn.InitialCatalog)) { MessageBox.Show("Seleccione o ingrese una base de datos.-", Fwk.GuidPk.Properties.Resources.ProductTitle); cmbDataBases.Focus(); return false; } if (!_cnn.WindowsAutentification) { if (string.IsNullOrEmpty(_cnn.User)) { MessageBox.Show("Ingrese usuario.-", Fwk.GuidPk.Properties.Resources.ProductTitle); txtUserName.Focus(); return false; } } SqlConnection sqlConnection = new SqlConnection(_cnn.ToString()); Microsoft.SqlServer.Management.Common.ServerConnection serverConnection = new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConnection); try { _Server = new Server(serverConnection); //_Server.Databases[_cnn.InitialCatalog].Tables.Refresh(); ////iterate over all Databases //foreach (Database db in _Server.Databases) //{ MessageBox.Show("Coneccion exitosa.- a " + _Server.Information.Product.ToString(), Fwk.GuidPk.Properties.Resources.ProductTitle); //} } catch (Exception ex) { MessageBox.Show(Fwk.CodeGenerator.HelperFunctions.GetAllMessageException(ex), Fwk.GuidPk.Properties.Resources.ProductTitle); return false; } return true; }
private void SetUI(CnnString cnn) { WindowsAutentificaction.Checked = cnn.WindowsAutentification; cmbDataBases.Text = cnn.InitialCatalog; cmbServer.Text = cnn.DataSource; if (cnn.WindowsAutentification) { txtUserName.Text = string.Empty; txtPassword.Text = string.Empty; txtUserName.Enabled = false; txtPassword.Enabled = false; lblUserName.ForeColor = System.Drawing.Color.Black; lblPassword.ForeColor = System.Drawing.Color.Black; } else { txtUserName.Text = cnn.User; txtPassword.Text = cnn.Password; txtUserName.Enabled = true; txtPassword.Enabled = true; lblUserName.ForeColor = System.Drawing.Color.DimGray; lblPassword.ForeColor = System.Drawing.Color.DimGray; } if (string.IsNullOrEmpty(cnn.DataSource) || string.IsNullOrEmpty(cnn.InitialCatalog)) return; txtCnnString.Text = cnn.ToString(); }