Hi

Is there a way to find distinct values of a column from
DataTable other than running a loop?

So far this what I did:
1. create a new table and added a new column
2. create a new view from existing table and sort it
3. loop thru the column, find a new value and add it to the new table.

Please do not suggest me to edit the SQL query that fills the datatable.
The filled database is already a summary of millions of records, I want to avoid the 2nd trip to the SQL server.

Does a DISTINCT help?

Select DISTINCT COL_NAME from TABLE_NAME.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Hi

Sorry I don't quite understand.
Here is my query:

SELECT company_id, produc_id, sum(amount)
FROM purchase
WHERE customer_id = 123
GROUP BY company_id, product_id;

This is of course a simplified version of the actual query.
I execute the query and store them in my DataSet

Now, I want to get a distinct company_id, how do I do it
from ASP.NET. rather than execute the 2nd Query something like
SELECT distinct company_id
FROM purchase
WHERE customer_id = 123

Because I will need to find distinct value of other columns as well.

You can allways do SQL-Ansi commands in your DataTables if you like.
That way you can save your SqlServer

peace

You can save your sql server by using sql-ansi like commands directly in your application datatables.

are you using visual studio 2005?

peace