How to iterate through rows of a query?

[Lacka]

Hi,

If I have this sequence:

Dim dbConnection As System.Data.IDb Connection = New
System.Data.Sql Client.SqlConne ction(Configura tionSettings.Ap pSettings("DB") )
Dim dbCommand As System.Data.IDb Command = New
System.Data.Sql Client.SqlComma nd
Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Sql Client.SqlDataA dapter
Dim dataSet As System.Data.Dat aSet = New System.Data.Dat aSet

dbCommand.Conne ction = dbConnection
dbCommand.Comma ndText = "SELECT * FROM MY_TABLE"

dataAdapter.Sel ectCommand = dbCommand

dataAdapter.Fil l(dataSet)

how can I iterate through the rows of the query, like this

<open result set>
<while not Eof(result set)>
<read in the current row>
<store fields into variables>
<do something with stored values>
<step result set forward ("next")>
<end while>
<close result set>

thanks,
Lacka

[Karl Seguin]

you mean like this:

for each row as DataRow in dataSet.Tables( 0).Rows
dim id as integer = convert.toInt32 (row("My_TableC olumn1"))
dim name as string = convert.ToStrin g(row("My_Table Column2"))
...
next

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Lacka" <la***@chello.h u> wrote in message
news:u7******** *****@TK2MSFTNG P11.phx.gbl...

Hi,

If I have this sequence:

Dim dbConnection As System.Data.IDb Connection = New
System.Data.Sql Client.SqlConne ction(Configura tionSettings.Ap pSettings("DB") ) Dim dbCommand As System.Data.IDb Command = New
System.Data.Sql Client.SqlComma nd
Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Sql Client.SqlDataA dapter
Dim dataSet As System.Data.Dat aSet = New System.Data.Dat aSet

dbCommand.Conne ction = dbConnection
dbCommand.Comma ndText = "SELECT * FROM MY_TABLE"

dataAdapter.Sel ectCommand = dbCommand

dataAdapter.Fil l(dataSet)

how can I iterate through the rows of the query, like this

<open result set>
<while not Eof(result set)>
<read in the current row>
<store fields into variables>
<do something with stored values>
<step result set forward ("next")>
<end while>
<close result set>

thanks,
Lacka

[Lacka]

Thanks!