Looping Data Grid Column

          DataTable dt = new DataTable();

          DataRow dr;

          dt.Columns.Add("Name", typeof(string));

          dt.Columns.Add("Add1", typeof(string));

          dt.Columns.Add("Add2", typeof(string));

          dr = dt.NewRow();

          dr["Name"] = "sadf";

          dr["Add1"] = "rwe";

          dr["Add2"] = null;

          dt.Rows.Add(dr);

          dr = dt.NewRow();

          dr["Name"] = "sadf2";

          dr["Add1"] = "rwe";

          dr["Add2"] = null;

          dt.Rows.Add(dr);

          dr = dt.NewRow();

          dr["Name"] = "sadf4";

          dr["Add1"] = "rwe";

          dr["Add2"] = null;

          dt.Rows.Add(dr);

          dr = dt.NewRow();

          dr["Name"] = "sadf5";

          dr["Add1"] = "rwe";

          dr["Add2"] = null;

          dt.Rows.Add(dr);

          foreach (var column in dt.Columns.Cast<DataColumn>().ToArray())

          {

              if (dt.AsEnumerable().All(dr1 => dr1.IsNull(column)))

                  dt.Columns.Remove(column);

          }

          GridView1.DataSource = dt;

          GridView1.DataBind();