Category Archives: Data Table

C# Data Table

Creating generic method or extension for searching through all the columns in DataTable in C#

22 August, 2012 – 1:46 pm

Few days ago I worked on a project where database table has more than 80 columns. My client asked to create a search so that it can search through all the columns. So I have decided to create an extension method which will search through all the columns in DataTable. Creating generic method or extension read more »

Tags , | Comment (0)
.Net Framework C# Data Table

Select Distinct Record from DataTable

5 January, 2011 – 3:37 pm

If it is necessary to select distinct record from Data Table, then we can use following method. public DataTable SelectDistinct(DataTable SourceTable, string FieldName) { DataTable dt = new DataTable(); dt = SourceTable.Clone(); object LastValue = null; foreach (DataRow dr in SourceTable.Select(“”, FieldName)) { if (LastValue == null || !(ColumnEqual(LastValue, dr[FieldName]))) { LastValue = dr[FieldName]; dt.ImportRow(dr); read more »

Tags | Comments (2)
Page 1 of 11