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 cboProcs_SelectedIndexChanged(object sender, EventArgs e)
{
if (lockout)
{
return;
}
if (UseDocConn)
{
dgrdParams.DataSource = _aDataObject.GetSchemaData(SchemaRestrictions.ProcedureParameters, cboProcedures.SelectedItem.ToString());
HideColumns();
ShowOnlyColumns();
}
}
public static void LoadToSQLEditor(CheckedListBox chckList, SchemaRestrictions restriction, String tableName, String extractField, DataBaseObjectClass aDataObject)
{
DataTable dt = aDataObject.GetSchemaData(restriction, tableName);
chckList.Items.Clear();
if (dt != null)
{
foreach (DataRow aRow in dt.Rows)
{
chckList.Items.Add(aRow[extractField].ToString());
}
}
else
{
MessageBox.Show("Restriction not valid");
}
}
public static List <String> LoadToList(SchemaRestrictions restriction, String tableName, String extractField, DataBaseObjectClass aDataObject)
{
List <String> result = new List <string>();
DataTable dt = aDataObject.GetSchemaData(restriction, tableName);
if (dt != null)
{
foreach (DataRow aRow in dt.Rows)
{
result.Add(aRow[extractField].ToString());
}
}
else
{
MessageBox.Show("Restriction not valid");
}
return(result);
}
public DataTable LoadSchema(SchemaRestrictions restriction, String tableName, DataBaseObjectClass aDataObject)
{
return(aDataObject.GetSchemaData(restriction, tableName));
}