private void FillDataGridView()
{
DrawingControl.SetDoubleBuffered(dgvData);
DrawingControl.SuspendDrawing(dgvData);
dgvData.DataSource = null;
dgvData.Columns.Clear();
dt.Columns.Clear();
dt.Clear();
da.Fill(dt);
dgvData.DataSource = dt.DefaultView;
dgvData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.ColumnHeader;
dgvData.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvData.ReadOnly = false;
//ID
dgvData.Columns["ID"].Visible = false;
dgvData.Columns["ID"].ReadOnly = true;
//ElementId
dgvData.Columns["ElementId"].Visible = false;
dgvData.Columns["ElementId"].ReadOnly = true;
//Mark
dgvData.Columns["Mark"].Visible = true;
dgvData.Columns["Mark"].ReadOnly = true;
dgvData.ClearSelection();
DrawingControl.ResumeDrawing(dgvData);
}
private void FilterTable(string _tableName)
{
tableIsBeingFiltered = true;
List <string> tableFields = new List <string>();
con.Open();
DataColumnCollection col;
col = dt.Columns;
foreach (DataColumn column in col)
{
if (column.ColumnName != "ID")
{
string param = column.ColumnName;
tableFields.Add(param);
}
}
string searchString = txtFilter.Text;
DrawingControl.SetDoubleBuffered(dgvData);
DrawingControl.SuspendDrawing(dgvData);
dgvData.DataSource = null;
dgvData.Columns.Clear();
DataView dsView = new DataView();
dsView = ds.Tables[0].DefaultView;
BindingSource bs = new BindingSource();
bs.DataSource = dsView;
string filterString = FilterLikeString(tableFields, searchString);
bs.Filter = filterString;
dgvData.DataSource = bs;
con.Close();
dgvData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.ColumnHeader;
dgvData.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvData.ReadOnly = false;
//ID
dgvData.Columns["ID"].Visible = false;
dgvData.Columns["ID"].ReadOnly = true;
//ElementId
dgvData.Columns["ElementId"].Visible = false;
dgvData.Columns["ElementId"].ReadOnly = true;
//Mark
dgvData.Columns["Mark"].Visible = true;
dgvData.Columns["Mark"].ReadOnly = true;
dgvData.ClearSelection();
DrawingControl.ResumeDrawing(dgvData);
}