is this dataset table select correct"

[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?

[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]

"GS" <gs**********************@msnews.Nomail.comschre ef in bericht
news:OM****************@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?

[gs]

thx, I will give another shot.

somehow I got nothing in dr while I do see the data in the studio preview.
"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:O3******************@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" <gs**********************@msnews.Nomail.comschre ef in bericht
news:OM****************@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?