private void LoadDbTableListBox(ref OperationResult op)
{
try
{
lbTables.Items.Clear();
DataTable dt = _mp3Repository.GetAllTables(ref op);
if (!op.Success)
{
rtbMessages.Text = op.GetAllErrorsAndExceptions("\n");
return;
}
BCHWinFormUtilities.DataTableToListBox(dt, lbTables, "name");
lbTables.SelectedIndex = 0;
LoadDbColumnListBox(lbTables.SelectedItem.ToString(), ref op);
if (!op.Success)
{
return;
}
}
catch (Exception ex)
{
op.AddException(ex);
return;
}
}
private void LoadDbColumnListBox(string tableName, ref OperationResult op)
{
try
{
lbColumns.Items.Clear();
DataTable dt = _mp3Repository.GetTableColumns(tableName, ref op);
if (!op.Success)
{
return;
}
BCHWinFormUtilities.DataTableToListBox(dt, lbColumns, "name");
}
catch (Exception ex)
{
op.AddException(ex);
}
}
private void LoadDbColumnListBox(string tableName, ref OperationResult op)
{
try
{
MP3DBManager mdbmgr = new MP3DBManager();
mdbmgr.SetDataStore(ddtbMp3DbFile.ItemText, ref op);
lbColumns.Items.Clear();
DataTable dt = mdbmgr.GetDbTableColumns(tableName, ref op);
BCHWinFormUtilities.DataTableToListBox(dt, lbColumns, "ColumnName");
}
catch (Exception ex)
{
op.AddException(ex);
rtbMessages.Text = op.GetAllErrorsAndExceptions("\n");
return;
}
}
private void LoadDbTableListBox(ref OperationResult op)
{
try
{
MP3DBManager mdbmgr = new MP3DBManager();
mdbmgr.SetDataStore(ddtbMp3DbFile.ItemText, ref op);
//string sql =
// "SELECT MSysObjects.Name AS TableName " +
// "FROM MSysObjects " +
// "WHERE (((Left([Name],1))<>\"~\") " +
// "AND ((Left([Name],4))<>\"MSys\") " +
// "AND ((MSysObjects.Type) In (1,4,6))) " +
// "order by MSysObjects.Name " +
// "";
lbTables.Items.Clear();
DataTable dt = mdbmgr.GetDbTables(ref op);
BCHWinFormUtilities.DataTableToListBox(dt, lbTables, "TABLE_NAME");
lbTables.SelectedIndex = 0;
LoadDbColumnListBox(lbTables.SelectedItem.ToString(), ref op);
if (!op.Success)
{
rtbMessages.Text = op.GetAllErrorsAndExceptions("\n");
return;
}
}
catch (Exception ex)
{
op.AddException(ex);
rtbMessages.Text = op.GetAllErrorsAndExceptions("\n");
return;
}
}
