Open Table And Set Columns

2015-06-10 11:46:37 访问(1498) 赞(0) 踩(0)

private void buttonOpenSearchTable_Click(object sender, System.EventArgs e)
		{
			Table searchTable;
			if (OpenTable(out searchTable)) 
			{
				if ( searchTable == null )
				{
					MessageBox.Show("Please specify a valid search table.");
					return;
				}
				if ( searchTable.IsMappable )
				{
					_searchTable = searchTable;
					//				searchTable.Close()
					textBoxSearchTable.Text = "";
					comboBoxSearchColumn.Items.Clear();
					comboBoxSearchColumn.Text = "";
					textBoxSearchString.Text = "";
					textBoxSearchTable.Text = _searchTable.TableInfo.Alias;
					SetColumnField(_searchTable,comboBoxSearchColumn);
				}
				else
				{
					MessageBox.Show(String.Format("Table " + _searchTable.Alias + " is not mappable."));
				}
			}
		}

		private void SetColumnField(Table table, System.Windows.Forms.ComboBox comboBox)
		{
			Columns columns = table.TableInfo.Columns;
			foreach ( Column column in columns)
			{
				if ( column.Indexed )
				{
					comboBox.Items.Add(column.Alias);
				}
			}
			
			if ( comboBox.Items.Count > 0 )
			{
				comboBox.SelectedIndex = 0;
			}
			else
			{
				MessageBox.Show(String.Format("No indexed columns in " + table.Alias + "."));
			}
		}