is this dataset table select correct"

26 Oct 2006 6:51 AM

GS

If I want to find in the row of "codetable" with codeTblName like
"mypattern%" and Code like "abc%"
MyDataSet.codetable.select("codeTblName like 'mypattern%' and Code like
'abc%'")

does the above have the select parameter in the correct format?

26 Oct 2006 8:30 AM

Michel Posseth [MCP]

Short answer for this question Yes

Please note that the select statement wil return a datarow array and not a
datatable

so if yiou want to loopt through the results you can do this

for each dr as datarow in MyDataSet.codetable.select("codeTblName like
'mypattern%' and Code like 'abc%'")

--- do your stuff

next

regards

Michel Posseth [MCP]

Show quoteHide quote

"GS" <gsmsnews.microsoft.co***@msnews.Nomail.com> schreef in bericht
news:OMs2qsM%23GHA.1200@TK2MSFTNGP02.phx.gbl...
> If I want to find in the row of "codetable" with codeTblName like
> "mypattern%" and Code like "abc%"
> MyDataSet.codetable.select("codeTblName like 'mypattern%' and Code like
> 'abc%'")
>
> does the above have the select parameter in the correct format?
>
>

27 Oct 2006 3:03 AM

gs

thx, I will give another shot.

somehow I got nothing in dr while I do see the data in the studio preview.
Show quoteHide quote

"Michel Posseth [MCP]" <M***@posseth.com> wrote in message
news:O3A%23qjN%23GHA.1784@TK2MSFTNGP04.phx.gbl...
> Short answer for this question Yes
>
> Please note that the select statement wil return a datarow array and not a
> datatable
>
> so if yiou want to loopt through the results you can do this
>
> for each dr as datarow in MyDataSet.codetable.select("codeTblName like
> 'mypattern%' and Code like 'abc%'")
>
> --- do your stuff
>
>
> next
>
> regards
>
> Michel Posseth [MCP]
>
> "GS" <gsmsnews.microsoft.co***@msnews.Nomail.com> schreef in bericht
> news:OMs2qsM%23GHA.1200@TK2MSFTNGP02.phx.gbl...
>> If I want to find in the row of "codetable" with codeTblName like
>> "mypattern%" and Code like "abc%"
>> MyDataSet.codetable.select("codeTblName like 'mypattern%' and Code like
>> 'abc%'")
>>
>> does the above have the select parameter in the correct format?
>>
>>
>
>