guys, Has anyone tried this before?
i have a dataset and rather than doing an addtional trip to the server with a DISTINCT sql query - i'd like to just loop thru the existing dataset in memory.
i assign that dataset (ds) to a datatable, declare a datarow and then use the select property to get the distinct employee id.
i keep getting "Syntax error: Missing operand after 'EmplId' operator." and i've pretty much been out on the web looking for a solution to this.
any help is appreciated. snippet of the code is below.
thanks
rik

Dim oTable As DataTable = ds.Tables(0)
Dim myRow As DataRow
For Each myRow In oTable.Select("DISTINCT EmplId")
cboEmplList2.Items.Add(myRow.Item(0))
Next


**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

http://support.microsoft.com/default...b;en-us;326176
"rik butcher" <(E-Mail Removed)> wrote in message
news:Ok%(E-Mail Removed)...
> guys, Has anyone tried this before?
> i have a dataset and rather than doing an addtional trip to the server
> with a DISTINCT sql query - i'd like to just loop thru the existing
> dataset in memory.
> i assign that dataset (ds) to a datatable, declare a datarow and then use
> the select property to get the distinct employee id.
> i keep getting "Syntax error: Missing operand after 'EmplId' operator."
> and i've pretty much been out on the web looking for a solution to this.
> any help is appreciated. snippet of the code is below.
> thanks
> rik
>
> Dim oTable As DataTable = ds.Tables(0)
> Dim myRow As DataRow
> For Each myRow In oTable.Select("DISTINCT EmplId")
> cboEmplList2.Items.Add(myRow.Item(0))
> Next
>
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
> ASP.NET resources...

Rik,

See this sample on our website

http://www.windowsformsdatagridhelp....2-1a580eb893b2

I hope this helps,

Cor

guys, i appreciate the help. this'll definately save a round trip and is extrememly fast since it's already in memory.
thanks again
rik

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...