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