public static void Main()
DataTable table = GenerateTable();
bool deleteColumn = false;
foreach (DataColumn c in table.Columns){
foreach (DataRow r in table.Rows){
if (String.IsNullOrWhiteSpace(r["Test3"].ToString())){
Console.WriteLine("Delete Column: " + deleteColumn);
public static DataTable GenerateTable()
DataTable table = new DataTable();
table.Columns.Add("Name", typeof (String));
table.Columns.Add("Age", typeof (Int32));
table.Columns.Add("Test2", typeof (String));
table.Columns.Add("Test3", typeof (String));
DataRow row1 = table.NewRow();
row1["Test2"] = "Cheese";
DataRow row2 = table.NewRow();
row2["Test2"] = "Cheese";
DataRow row3 = table.NewRow();
row3["Test2"] = "Cheese";
foreach (DataRow d in table.Rows)
Console.WriteLine(d["Name"] + " | " + d["Age"] + " | " + d["Test2"] + " | " + d["Test3"] + " | ");