Wednesday, 29 August 2018

Comma Separated String Filter Data Table C#

string pStrEmpEditValue = CmbValue.EditValue.ToString();

DataTable table = new DataTable();
table.Columns.Add("value", typeof(string));
string[] values = CmbValue.EditValue.ToString().Split(',');

for (int i = 0; i < values.Length; i++)
{
table.Rows.Add(new object[] { values[i].ToString().Trim() });
}

DataTable _Final = DTResultSave.Clone();
_Final.Rows.Clear();
foreach (DataRow item in table.Rows)
{
String author = item["value"].ToString().Trim();
//bool contains = DTResult.AsEnumerable().Any(row => author.ToString().ToUpper() == row.Field<String>("EmpCode"));
DataRow[] rowsToCopy;
rowsToCopy = DTResultSave.Select("EmpCode='" + author.ToString().ToUpper() + "'");
if (rowsToCopy.Any())
{
foreach (DataRow temp in rowsToCopy)
{
_Final.ImportRow(temp);
}
}
}

No comments:

Post a Comment