private void cboDbServerConnections_SelectedIndexChanged_1(object sender, EventArgs e)
{
string connectionString = cboDbServerConnections.ValueMember.ToString();
if (!connectionString.Contains("=") || string.IsNullOrEmpty(connectionString))
{
connectionString = cboDbServerConnections.SelectedValue.ToString();
}
if (!connectionString.Contains("=") || string.IsNullOrEmpty(connectionString))
{
return;
}
//TableList
List <ConnectionString> connectionStringList = null;
connectionStringList = new List <ConnectionString>();
DbConnectionOptions dbconnectionOption = new DbConnectionOptions();
dbconnectionOption.DbConnectionString = connectionString;
dbconnectionOption.DbConnectionType = DatabaseConnectionType.MsSql;
DataRequest dataRequest = new DataRequest();
DataSet ds = dataRequest.GetDataset(dbconnectionOption, tablelistquery);
if (ds.Tables.Count > 0)
{
foreach (DataRow r in ds.Tables[0].Rows)
{
ConnectionString connectionStringClass = new ConnectionString();
connectionStringClass.Name = r["name"].ToString();
connectionStringClass.Value = r["name"].ToString();
connectionStringList.Add(connectionStringClass);
}
}
cboTables.DataSource = connectionStringList;
cboTables.DisplayMember = "Name";
cboTables.ValueMember = "Value";
cboTables.Refresh();
}
public void VoidLoadDefaults()
{
rdoCsv.Checked = true;
rdoCsv.Refresh();
rdoUseSourceTables.Checked = true;
rdoMultipleFiles.Checked = true;
//Load Database Connection
string connectionsfile = Properties.Settings.Default.ConnectionFile;
IList <ConnectionString> connectionStringList = null;
connectionStringList = new List <ConnectionString>();
foreach (string line in File.ReadLines(connectionsfile))
{
string[] connections = line.Split('|');
ConnectionString connectionString = new ConnectionString();
connectionString.Name = connections[0];
connectionString.Value = connections[1];
connectionStringList.Add(connectionString);
}
cboDbServerConnections.DataSource = connectionStringList;
cboDbServerConnections.DisplayMember = "Name";
cboDbServerConnections.ValueMember = "Value";
cboDbServerConnections.Refresh();
//TableList
connectionStringList = new List <ConnectionString>();
DbConnectionOptions dbconnectionOption = new DbConnectionOptions();
dbconnectionOption.DbConnectionString = cboDbServerConnections.SelectedValue.ToString();
dbconnectionOption.DbConnectionType = DatabaseConnectionType.MsSql;
DataRequest dataRequest = new DataRequest();
DataSet ds = dataRequest.GetDataset(dbconnectionOption, tablelistquery);
if (ds.Tables.Count > 0)
{
foreach (DataRow r in ds.Tables[0].Rows)
{
ConnectionString connectionString = new ConnectionString();
connectionString.Name = r["name"].ToString();
connectionString.Value = r["name"].ToString();
connectionStringList.Add(connectionString);
}
}
cboTables.DataSource = connectionStringList;
cboTables.DisplayMember = "Name";
cboTables.ValueMember = "Value";
cboTables.Refresh();
//Log Window
//Update Date GridView
Type t = typeof(Log);
PropertyInfo[] pia = t.GetProperties();
foreach (PropertyInfo pi in pia)
{
if ((pi.PropertyType.IsGenericType))
{
Type typeOfColumn = pi.PropertyType.GetGenericArguments()[0];
logDataGridView.Columns.Add(pi.Name, pi.Name);
}
else
{
logDataGridView.Columns.Add(pi.Name, pi.Name);
}
}
}
