foreach (DataGridViewColumn col in dgvActiveBlocks.Columns) { col.Visible = new List<string>() { "PaymentBlock", "RaisedBy", "BlockDescription", "etc" } .Contains(col.Name); }~~Bonnie
foreach (DataGridViewColumn col in dgvActiveBlocks.Columns) > { > col.Visible = new string[] { > "PaymentBlock", > "RaisedBy", > "BlockDescription", > "etc" } > .Contains(col.Name); > }Shorter, but dunno if it's quicker :-}
>>this.dgvActiveBlocks.DataSource = this.dsBlocks.Tables[0]; >>>>
>>this.dgvActiveBlocks.AutoGenerateColumns = true; >>>>
>>foreach (DataGridViewColumn col in this.dataGridView1.Columns) >>{ >> col.Visible = false; >>} >>this.dataGridView1.Columns["PaymentBlock"].Visible = true; >>this.dataGridView1.Columns["BlockDescription"].Visible = true; >>this.dataGridView1.Columns["RaisedBy"].Visible = true; >>this.dataGridView1.Columns["RaisedDate"].Visible = true; >>this.dataGridView1.Columns["RaisedDepartment"].Visible = true; >>this.dataGridView1.Columns["Status"].Visible = true; >>>>
>>DataGridViewTextBoxColumn[] cols = new DataGridViewTextBoxColumn[6]; >>cols[0] = new DataGridViewTextBoxColumn(); >>cols[0].DataPropertyName = "PaymentBlock"; >>cols[0].HeaderText = "Payment Block"; >>cols[1] = new DataGridViewTextBoxColumn(); >>cols[1].DataPropertyName = "BlockDescription"; >>cols[1].HeaderText = "BlockDescription"; >>// etc. for the rest of the columns >>this.dataGridView1.Columns.AddRange(cols); >>>>
>>>foreach (DataRow dr in this.dsBlocks.Tables[0].Rows) >>>{ >>> Object[] cells = {dr["PaymentBlock"].ToString(), >>> dr["BlockDescription"].ToString(), >>> dr["RaisedBy"].ToString(), >>> dr["RaisedDate"].ToString(), >>> dr["RaisedDepartment"].ToString(), >>> dr["Status"]}; >>> >>> this.dgvActiveBlocks.Rows.Add(cells); >>>} >>>>>>