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