private void Form1_Load(object sender, EventArgs e)
{
// Reading the data
DataSet ds = new DataSet();
ds.ReadXml(@"Quarterly_orders.xml");
// Databinding
dataGridView1.DataSource = ds.Tables[0];
// Use of the DataGridViewColumnSelector
DataGridViewColumnSelector cs = new DataGridViewColumnSelector(dataGridView1);
cs.MaxHeight = 100;
cs.Width = 110;
}
private void OpenTable(string tableName)
{
// Display New Tab
if (tabControl.TabPages.ContainsKey(tableName) == true || tableListBox.SelectedIndex == -1) {
tabControl.SelectedTab = tabControl.TabPages[tableName];
return;
}
TabPage tp = new TabPage(tableName);
tp.Name = tableName;
DataGridView dgv = new DataGridView();
dgv.Dock = DockStyle.Fill;
dgv.AlternatingRowsDefaultCellStyle.BackColor = ColorTranslator.FromHtml("#E8EDFF");//#E0E0E0
dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgv.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText;
dgv.AllowUserToAddRows = false;
dgv.KeyDown += new KeyEventHandler(dgv_KeyDown);
dgv.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(dgv_DataBindingComplete);
dgv.DataError += new DataGridViewDataErrorEventHandler(dgv_DataError);
//dgv.CellDoubleClick += new DataGridViewCellEventHandler(dgv_CellDoubleClick);
dgv.CellMouseDown += new DataGridViewCellMouseEventHandler(dgv_CellMouseDown);
dgv.ColumnHeaderMouseClick += new DataGridViewCellMouseEventHandler(dgv_ColumnHeaderMouseClick);
dgv.MouseEnter += dgv_MouseEnter;
dgv.DataSource = dbFile.Tables[tableName];
DataGridViewColumnSelector dgvcs = new DataGridViewColumnSelector(dgv);
DgvFilterManager dgvfm = new DgvFilterManager(dgv);
tp.Controls.Add(dgv);
tabControl.TabPages.Add(tp);
foreach (DataColumn col in dbFile.Tables[tableName].Columns) {
if (col.DataType == typeof(string)) {
if (dgv.Columns[col.ColumnName] is DataGridViewTextBoxColumn && col.MaxLength >= 0) {
((DataGridViewTextBoxColumn)dgv.Columns[col.ColumnName]).MaxInputLength = col.MaxLength;
}
}
}
tabControl.SelectedIndex = tabControl.TabPages.Count - 1;
//tabControl.Focus();
}
