Selecting Dataset records

[rodchar]

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/ar...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
Editor, .netWire
www.dotnetwire.com
"rodchar" <ro*****@discus sions.microsoft .com> wrote in message
news:2F******** *************** ***********@mic rosoft.com...

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]

Just realized there is a KB article as well:

http://support.microsoft.com/default...b;en-us;326176

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Manohar Kamath" <mk*****@TAKETH ISOUTkamath.com > wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

No, but this article could help you build one:

http://weblogs.sqlteam.com/davidm/ar...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
Editor, .netWire
www.dotnetwire.com
"rodchar" <ro*****@discus sions.microsoft .com> wrote in message
news:2F******** *************** ***********@mic rosoft.com...

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

[rodchar]

Thanks everyone for the feedback.

"rodchar" wrote:

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

[rodchar]

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(Table Name)
dt.Columns.Add( FieldName, SourceTable.Col umns(FieldName) .DataType)

Dim LastValue As Object = Nothing
Dim dr As DataRow
For Each dr In SourceTable.Sel ect("", FieldName)
If LastValue Is Nothing Or Not ColumnEqual(Las tValue,
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(d t)
End If
Return dt
End Function 'SelectDistinct

"rodchar" wrote:

Thanks everyone for the feedback.

"rodchar" wrote:

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