Selecting Dataset records

[Guest]

Hey all,

Is there a way to get similar functionality as the SELECT DISTINCT records
in a SQL Statement when selecting records from a dataset?

thanks,
rodchar

 

[Manohar Kamath]

No, but this article could help you build one:

http://weblogs.sqlteam.com/davidm/archive/2004/01/21/753.aspx

Essentially, you need to traverse all rows and choose only those that have
distinct column values you are looking for.

 

[Manohar Kamath]

Just realized there is a KB article as well:

http://support.microsoft.com/default.aspx?scid=kb;en-us;326176

 

[Guest]

Thanks everyone for the feedback.

 

[Guest]

Hey I have question about the code. Why use Object as data type for
LastValue? Very new to objects.

Public Function SelectDistinct(ByVal TableName As String, ByVal
SourceTable As DataTable, ByVal FieldName As String) As DataTable
Dim dt As New DataTable(TableName)
dt.Columns.Add(FieldName, SourceTable.Columns(FieldName).DataType)

Dim LastValue As Object = Nothing
Dim dr As DataRow
For Each dr In SourceTable.Select("", FieldName)
If LastValue Is Nothing Or Not ColumnEqual(LastValue,
dr(FieldName)) Then
LastValue = dr(FieldName)
dt.Rows.Add(New Object() {LastValue})
End If
Next dr
If Not (ds Is Nothing) Then
ds.Tables.Add(dt)
End If
Return dt
End Function 'SelectDistinct