private void DBListLookUpEdit_EditValueChanged(object sender, EventArgs e)
{
try
{
if (DBListLookUpEdit.Text == "System.Data.DataRowView")
{
return;
}
var ds = new DataTable();
if (Settings.Default.DatabaseTypes == "SQLite")
{
//ds = UtilsTableSQLite.AddTableListBox(FileName);
List <string> tables = UtilsTableSQLite.GetListTables(FileName);
TableNamesListBox.Items.Clear();
TableNamesListBox.Items.AddRange(tables.ToArray());
}
else if (Settings.Default.DatabaseTypes == "SQL")
{
ds = UtilsTable.AddTableListBox(DBListLookUpEdit.Text, Settings.Default.teServer);
TableNamesListBox.Items.Clear();
for (var i = 0; i <= ds.Rows.Count - 1; i++)
{
TableNamesListBox.Items.Add(ds.Rows[i].ItemArray[0].ToString());
}
}
}
catch (Exception ex)
{
EventscadaException?.Invoke(this.GetType().Name, ex.Message);
}
}
private void DBListLookUpEdit_ButtonClick(object sender, ButtonPressedEventArgs e)
{
if (Settings.Default.DatabaseTypes == "SQLite")
{
// Show the dialog and get result.
openFileDialog.Filter = "db3 Files (*.db3)|*.db3|All files (*.*)|*.*";
openFileDialog.FileName = "config";
var result = openFileDialog.ShowDialog();
if (result == DialogResult.OK) // Test result.
{
FileName = openFileDialog.FileName;
dt = UtilsTableSQLite.AddDatabases(openFileDialog.FileName);
DBListLookUpEdit.Properties.DataSource = dt;
DBListLookUpEdit.Properties.DisplayMember = "DatabaseName";
DBListLookUpEdit.Properties.ValueMember = "DBId";
}
}
else if (Settings.Default.DatabaseTypes == "SQL")
{
dt = UtilsTable.AddDatabases(Settings.Default.teServer);
DBListLookUpEdit.Properties.DataSource = dt;
DBListLookUpEdit.Properties.DisplayMember = "DatabaseName";
DBListLookUpEdit.Properties.ValueMember = "DBId";
}
}
private void TableNamesListBox_MouseClick(object sender, MouseEventArgs e)
{
try
{
if (Settings.Default.DatabaseTypes == "SQLite")
{
var dt = new DataTable();
dt = UtilsTableSQLite.ColumnExists(TableNamesListBox.Text, FileName);
ColumnLookUpEdit.DataSource = dt;
}
else if (Settings.Default.DatabaseTypes == "SQL")
{
var dt = new DataTable();
dt = UtilsTable.AddColumnGrid(DBListLookUpEdit.Text, TableNamesListBox.Text, Settings.Default.teServer);
ColumnLookUpEdit.DataSource = dt;
}
}
catch (Exception ex)
{
EventscadaException?.Invoke(this.GetType().Name, ex.Message);
}
}
