int i = 1; foreach (DataRow row in lstDS[0].Tables[0].Rows) { xlWorkSheet1.Cells[i, 1] = row[2]; i++; }
foreach (DataRow row in lstDS[0].Tables[0].Rows) { string fieldFromDB=row[2].toString(); if (fieldFromDB.StartsWith("GW")) { xlWorkSheet1.Cells[i, 1] = row[2]; i++; } }
string[] st = System.Text.RegularExpressions.Regex.Split(row, "GW");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)