datatable.select("dintinct columnName");

S Aijaz

i want to get distinct values of a column in datatable in asp.net. is it possible and how? thanks

padmanabhan N

much clearly explanation would help our experts to give accurate answer.... :rolleyes:

S Aijaz

i have a datatable "TableA" with columns CompanyName EmployeeName EmployeeSalary CompanyName gets repeated in the datatable i want company name in some other datatable say "TableB" and company name should be only once in the column. i want to run query on TableA.Select("Query"); to get unique CompanyName and add these rows to TableB. All i know but wt i nyd to know is wt shd be d query for it. i tries select distinct CompanyName but it thorows an exception

Baran M

Please try this [^]

Education is not a way to escape poverty — it is a way of fighting it.

himanshu2561

If you are using .net framework 3.5 then use LINQ as follows

var query = (from c in dt.AsEnumerable() select new { FirstName = c.Field<string>("FirstName"), LastName = c.Field<string>("LastName") }).Distinct() ;

It will give you distinct values.

himanshu

S Aijaz

im working on ADO.net not LINQ

himanshu2561

Hi Aijaz, But if you are working on framework 3.5 then you can use the code i have posted above. If not then you might be need to create dataview and then filter rows from there.

himanshu

S Aijaz

thnku himanshu it worked

Kaushal Arora

You can try hashtables for doing this. But the best way is to change the display at runtime by merging the cells in gridview. You can have a look at this: http://forums.asp.net/p/1053747/1494505.aspx[^] Regards, Kaushal Arora Mark as Answer if it Solved Your Problem.