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