How to do it
I have used below code.
for (int i = 0; i < ds.Tables.Count; i++)
{
for (int j = 0; j < ds.Tables[i].Columns.Count; j++)
{
if (ds.Tables[i].Rows[7][j].ToString().Trim().Contains("Lead Time (WEEKS)"))
{
int y = j;
if (ds.Tables[i].Rows[7][y + 1].ToString().Trim() == "" || ds.Tables[i].Rows[7][y + 1].ToString().Trim() != "")
{ int y1 = y + 1;
ds.Tables[i].Columns.RemoveAt(y1);
}
}
}
}

Ananth GPosted Nov 1, 2016, 4:50 AM
Manas MohapatraPosted Nov 1, 2016, 2:52 AM
Salman BegPosted Nov 1, 2016, 2:49 AM