private void frmTables_Load(object sender, EventArgs e)
{
// Populate the Language Pulldown
ProgSettings.LoadLangs(lstLangs);
// The following command reads all the columns for the selected table
var dbViewList =
ProgSettings.SelectRows(
"SELECT T.TABLE_NAME AS TableName, T.ENGINE AS TableEngine, T.TABLE_COMMENT AS TableComment FROM INFORMATION_SCHEMA.Tables T WHERE T.TABLE_NAME <> 'dtproperties' AND T.TABLE_SCHEMA <> 'INFORMATION_SCHEMA' AND T.TABLE_SCHEMA='" +
ProgSettings.DbName + "' ORDER BY T.TABLE_NAME");
// Did we return anything
if (dbViewList != null)
{
// Do we have rows
if (dbViewList.Tables[0].Rows.Count > 0)
{
lstTables.Items.Clear();
// for each Field returned, populate the listbox with the table name
for (var thisRow = 0; thisRow <= dbViewList.Tables[0].Rows.Count - 1; thisRow++)
{
var tableName = dbViewList.Tables[0].Rows[thisRow]["TableName"].ToString();
lstTables.Items.Add(tableName);
}
}
}
blnTextChanged = false;
}
private void frmFields_Load(object sender, EventArgs e)
{
Text = Resources.DBDocs_for_Table + TableName;
ProgSettings.LoadLangs(lstLangs);
// The following command reads all the columns for the selected table
var dbViewList = ProgSettings.SelectRows("SHOW COLUMNS FROM " + TableName);
// Did we return anything
if (dbViewList != null)
{
// Do we have rows
if (dbViewList.Tables[0].Rows.Count > 0)
{
lstFields.Items.Clear();
// for each Field returned, populate the listbox with the column name
for (var thisRow = 0; thisRow <= dbViewList.Tables[0].Rows.Count - 1; thisRow++)
{
var fieldName = dbViewList.Tables[0].Rows[thisRow]["Field"].ToString();
lstFields.Items.Add(fieldName);
}
}
}
blnTextChanged = false;
}
private void frmsubtables_Load(object sender, EventArgs e)
{
// Populate the Language Pulldown
ProgSettings.LoadLangs(lstLangs);
DataSet dbViewList;
if (SubTableId == 0)
{
// The following command reads all the columns for all the subtables
dbViewList = ProgSettings.SelectRows("SELECT subtablename from dbdocssubtables");
}
else
{
// The following command reads all the columns for just the selected subtable
dbViewList =
ProgSettings.SelectRows("SELECT subtablename from dbdocssubtables where subtableid=" + SubTableId);
}
// Did we return anything
if (dbViewList == null)
{
return;
}
// Do we have rows
if (dbViewList.Tables[0].Rows.Count <= 0)
{
return;
}
// for each Field returned, populate the listbox with the table name
for (var thisRow = 0; thisRow <= dbViewList.Tables[0].Rows.Count - 1; thisRow++)
{
var fieldName = dbViewList.Tables[0].Rows[thisRow]["subtablename"].ToString();
lstsubtables.Items.Add(fieldName);
}
if (SubTableId != 0)
{
//Select the first entry if we passed in an Id
if (lstsubtables.SelectedIndex < 0)
{
lstsubtables.SelectedIndex = 0;
}
Text = Resources.SubTable + lstsubtables.Text;
}
else
{
Text = Resources.SubTables;
}
blnTextChanged = false;
}