private void comboxDb_SelectionChangeCommitted(object sender, EventArgs e)
{
dbName = comboxDb.GetItemText(comboxDb.Items[comboxDb.SelectedIndex]);//获取 comboxTb.DisplayMember = "TableComment";不要用comboxTb.Text;,指定显示的数据项;
server.DbName = dbName;
dtTable = bllDatabase.GetDataTableNames();
if (dtTable == null) { return; }
if (comboxTb.Items.Count > 0)
{
comboxTb.DataSource = null;
comboxTb.Items.Clear();
}
comboxTb.DataSource = dtTable; //将lst列表绑定到combobx
comboxTb.DisplayMember = "TableComment";// 指定显示的数据项
comboxTb.ValueMember = "TABLE_NAME"; //指定comboBox1.SelectedValue返回的数据项
}
private void comboxTb_SelectionChangeCommitted(object sender, EventArgs e)
{
tbName = comboxTb.SelectedValue.ToString();//获取 comboxTb.ValueMember = "TABLE_NAME"
tbNameComment = comboxTb.GetItemText(comboxTb.Items[comboxTb.SelectedIndex]); //获取 comboxTb.DisplayMember = "TableComment";不要用comboxTb.Text;,指定显示的数据项;
dtData = bllDatabase.GetDataTable(tbName);
dtData.TableName = tbName;
if (dtData == null) { return; }
dataGridView2.DataSource = dtData; //用DataTable来绑定
}
