private void RefreshDatabase()
{
cbConnectStringName.Items.Clear();
var list = dal.FindAll().ToList();
var itemList = new List <ComboBoxItem>();
foreach (var item in list)
{
if (item.IsActive)
{
var boxItem = new ComboBoxItem();
boxItem.Text = item.Name;
boxItem.Value = item.ConnectionString;
if (!itemList.Contains(boxItem))
{
itemList.Add(boxItem);
}
}
}
cbConnectStringName.DataSource = itemList;
cbConnectStringName.DisplayMember = "Text";
cbConnectStringName.ValueMember = "Value";
}
private void RefreshDatabase()
{
cbConnectStringName.Items.Clear();
var list = dal.FindAll().ToList();
foreach (var item in list)
{
if (item.IsActive)
{
cbConnectStringName.Items.Add(item.Name);
}
}
}
public void RefreshDatabase()
{
cbConnectionStrings.Items.Clear();
tvDatabase.Nodes.Clear();
var dal = new DbConnDAL();
//dal.InitData();
var list = dal.FindAll().ToList();
foreach (var item in list)
{
if (item.IsActive)
{
cbConnectionStrings.Items.Add(item.Name);
}
}
}
private void DbSchemaViewer_Load(object sender, EventArgs e)
{
var dal = new DbConnDAL();
//dal.InitData();
var list = dal.FindAll().ToList();
foreach (var item in list)
{
if (item.IsActive)
{
cbConnectionStrings.Items.Add(item.Name);
}
}
cbSchemaName.DataSource = new string[] {
"MetaDataCollections",
"Databases",
"Catalogs",
"Users",
"Tables",
"Columns",
"Views",
"ViewColumns",
"Procedures",
"ProcedureParameters",
"Indexes",
"IndexColumns",
"ForeignKeys",
"UserDefinedTypes",
"StructuredTypeMembers",
"DataSourceInformation",
"DataTypes",
"Restrictions",
"ReservedWords"
};
}
private void DbDocBuilder_Load(object sender, EventArgs e)
{
var dal = new DbConnDAL();
//dal.InitData();
var list = dal.FindAll().ToList();
foreach (var item in list)
{
if (item.IsActive)
{
cbConnectionStrings.Items.Add(item.Name);
}
}
if (string.IsNullOrEmpty(CSName) == false)
{
ChangeConnection(CSName);
}
if (CurrentDatabase != null)
{
ChangeDatabase(CurrentDatabase);
}
}