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; }