private void ShowDataInDataGridView(string sql, DataGridViewEx mydgv, string wherestr, string sqlstr)
{
mydgv.SetDataGridViewTheme2(true, false, "No", true, true, 32, 22, true, false, false);
mydgv.DefaultCellStyle = DataCellStyle1;
mydgv.AllowUserToOrderColumns = false;
//mydgv.AllowUserToResizeColumns = false;
mydgv.AllowUserToResizeRows = false;
DataTable dt = cs.GetDataTable(sql, wherestr, sqlstr);
this.bindingSource1.DataSource = dt;
mydgv.DataSource = null;
mydgv.DataSource = this.bindingSource1;
mydgv.CurrentCell = null;
if (this.rdtable6.Checked)
{
dt.TableName = "AdjustQty";
mydgv.Columns["KeyID"].ReadOnly = true;
mydgv.Columns["Code"].ReadOnly = true;
mydgv.Columns["InputTime"].ReadOnly = true;
mydgv.Columns["UserID"].ReadOnly = true;
mydgv.Columns["KeyID"].Visible = false;
mydgv.Columns["Code"].Visible = false;
mydgv.Columns["InputTime"].Visible = false;
mydgv.Columns["UserID"].Visible = false;
}
}
private void ShowDataInDataGridView(string sql, DataGridViewEx mydgv)
{
mydgv.SetDataGridViewTheme2(true, false, "No", false, false, 32, 25, true, false, false);
mydgv.DefaultCellStyle = DataCellStyle1;
mydgv.AllowUserToOrderColumns = false;
mydgv.AllowUserToResizeColumns = false;
mydgv.AllowUserToResizeRows = false;
mydgv.ReadOnly = true;
DataTable dt = db.GetDataTable(sql);
mydgv.DataSource = null;
mydgv.DataSource = dt.DefaultView;
mydgv.CurrentCell = null;
}