Querying data from DataTable

Results 1 to 2 of 2

Thread: Querying data from DataTable

  1. #1
    Join Date
    Dec 1969

    Default Querying data from DataTable

    Hi,<BR><BR>I have a Datatable which is being used by others also and cannot be changed for that matter, I need some selected columns to be selected from the datatable. The problem is that the values of the columns that I&#039;m trying to select are repeating due to presence of some unique values of another column the values of which are out of my scope. Is there any way that I can select the distinct values ( as with distinct in SQL query)?<BR>Thanks<BR>Abhra

  2. #2
    Join Date
    Dec 1969

    Default RE: Querying data from DataTable

    &nbsp;<BR>Hi Abhra,<BR><BR>Microsoft has released several Knowledge Base articles that introduce helper functions for working with datasets. The one you will be most interested in is:<BR><BR>HOW TO: Implement a DataSet SELECT DISTINCT Helper Class in Visual C# .NET<BR>http://support.microsoft.com/default.aspx?scid=kb;en-us;326176<BR><BR>and for the rest of the articles, check out:<BR><BR>http://support.microsoft.com/common/canned.aspx?R=d&H=ADO.NET%20DataSet%20Helper%20Art icles&LL=kbadonet&Sz=kbhowto%20and%20datasethelper %20and%20kbadonet<BR><BR>(watch for line breaks!)<BR><BR>Hope this helps,<BR>-Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts