public static void LoadDatabase(TreeView projectView, ref DataBaseObjectClass aDataObject, ListView lstVwDatabaseTables) { DataBaseSelection openDatabase = new DataBaseSelection(); openDatabase.IntitialFolderPath = Application.StartupPath; if (openDatabase.ShowDialog() == DialogResult.OK) { projectView.Nodes[0].Nodes[0].Nodes.Clear(); DataLogin dataLogin = openDatabase.Connection; aDataObject = new DataBaseObjectClass(dataLogin.FromDatabase.DataBaseType); aDataObject.Connection(dataLogin.FromDatabase.ServerFile, dataLogin.FromDatabase.DatabaseName, dataLogin.FromDatabase.UserID, dataLogin.FromDatabase.Password, dataLogin.FromDatabase.Integrated); DataTable dt = aDataObject.GetSchemaData(SchemaRestrictions.Tables, null); lstVwDatabaseTables.Items.Clear(); if (dt != null) { foreach (DataRow aRow in dt.Rows) { lstVwDatabaseTables.Items.Add(aRow["TABLE_NAME"].ToString()); } projectView.Nodes[0].Nodes[0].Nodes.Add("Server: " + dataLogin.FromDatabase.ServerFile); projectView.Nodes[0].Nodes[0].Nodes.Add("Database Name: " + dataLogin.FromDatabase.DatabaseName); } else { MessageBox.Show("Restriction not valid"); } } }
private void tsbDbConnect_Click(object sender, EventArgs e) { DataBaseSelection openDatabase = new DataBaseSelection(); openDatabase.IntitialFolderPath = Application.StartupPath; if (openDatabase.ShowDialog() == DialogResult.OK) { DataLogin dataLogin = openDatabase.Connection; _aDataObject = new DataBaseObjectClass(dataLogin.FromDatabase.DataBaseType); _aDataObject.Connection(dataLogin.FromDatabase.ServerFile, dataLogin.FromDatabase.DatabaseName, dataLogin.FromDatabase.UserID, dataLogin.FromDatabase.Password, dataLogin.FromDatabase.Integrated); lblDB.Text = _aDataObject.DatabaseName; lblServer.Text = _aDataObject.ServerOrFile; TablesAndViewsUI.DataInitialization(_aDataObject); ProceduresAndFunctions.DataInitialization(_aDataObject); SQLView.DataInitialization(_aDataObject); } }