コード例 #1
0
        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);
            }
        }