private void toolStripTextBox1_TextChanged(object sender, EventArgs e)
{
int dataTableSelectedIndex = tabControl1.SelectedIndex;
DataTable dataTable = DataBasaManeger.GetTypeDateSet().Tables[dataTableSelectedIndex];
DataView dataView = dataTable.AsDataView();
dataView.RowFilter = string.Format("convert({0},System.String) LIKE '{1}%'", DataBasaManeger.EscapeLikeValue(toolStripComboBox1.Text), DataBasaManeger.EscapeLikeValue(toolStripTextBox1.Text));
adventureWorksLT2008DataSetBindingSource.DataSource = dataView;
bindingNavigator1.BindingSource = adventureWorksLT2008DataSetBindingSource;
dataGridView1.DataSource = adventureWorksLT2008DataSetBindingSource;
}
private void tabControl1_Selecting(object sender, TabControlCancelEventArgs e)
{
DataTable dataTableSource = DataBasaManeger.GetTypeDateSet().Tables[e.TabPage.Text];
adventureWorksLT2008DataSetBindingSource.DataSource = dataTableSource;
bindingNavigator1.BindingSource = adventureWorksLT2008DataSetBindingSource;
dataGridView1.DataSource = adventureWorksLT2008DataSetBindingSource;
toolStripComboBox1.Items.Clear();
foreach (DataColumn column in dataTableSource.Columns)
{
toolStripComboBox1.Items.Add(column.ColumnName);
}
toolStripComboBox1.SelectedIndex = 0;
}
private void Form1_Load(object sender, EventArgs e)
{
foreach (DataTable dataTable in adventureWorksLT2008DataSet.Tables)
{
tabControl1.Controls.Add(new TabPage()
{
Name = dataTable.TableName, Text = dataTable.TableName
});
}
DataTable dataTableActiv = DataBasaManeger.GetTypeDateSet().Tables[tabControl1.TabPages[0].Text];
adventureWorksLT2008DataSetBindingSource.DataSource = dataTableActiv;
bindingNavigator1.BindingSource = adventureWorksLT2008DataSetBindingSource;
dataGridView1.DataSource = adventureWorksLT2008DataSetBindingSource;
foreach (DataColumn column in dataTableActiv.Columns)
{
toolStripComboBox1.Items.Add(column.ColumnName);
}
toolStripComboBox1.SelectedIndex = 0;
}
