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