DataTable dt = new DataTable();
DataRow[] rows;
if (getdt.Columns.Count > 0)
{
for (int j = 0; j < getdt.Columns.Count; j++)
{
string s = getdt.Columns[j].ColumnName + " not like '--%'";
rows = getdt.Select(s);
}
for (int j = 0; j < 6; j++)
{
foreach (DataRow row in rows)
{
DataRow newRow = dt.NewRow();
newRow[getdt.Columns[j].ColumnName] = row[getdt.Columns[j].ColumnName];
dt.Rows.Add(newRow);
}
}
}