Tuesday, July 03, 2007

DataView Sorting, Filtering and DataBinding in ADO.NET 2.0

Converting DataView to Table - ADO.NET Tutorials : http://davidhayden.com/blog/dave/archive/2006/02/11/2798.aspx

if (strTripType.Equals("BV"))
{
dvFTRList = new DataView(dtFTRList, "TVISA = 'BV' or TVISA = 'B1'", "TVISA", DataViewRowState.CurrentRows);
}
else
{
dvFTRList = new DataView(dtFTRList, "TVISA <> 'BV' and TVISA <> 'B1'", "TVISA", DataViewRowState.CurrentRows);
}

No comments: