resultDataGrid is populated from resultDataSet, which is populated directly from SQL.

private void formatDataGridColumns()
{
  for(int i=0;i<resultdataset .Tables[0].Columns.Count;i++)
  {
    BoundColumn objbc = new BoundColumn();
    objbc.DataField =  _
resultDataSet.Tables[0].Columns[i].ColumnName;
    objbc.HeaderText = _
resultDataSet.Tables[0].Columns[i].ColumnName;
    resultDataGrid.Columns.Add(objbc);
    objbc.Visible = false;
    if (objbc.HeaderText == _
"PreferredName" || objbc.HeaderText == "department")
    {
      objbc.Visible=true;
    }
  }
}