L
Lacka
Hi,
If I have this sequence:
Dim dbConnection As System.Data.IDbConnection = New
System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings("DB"))
Dim dbCommand As System.Data.IDbCommand = New
System.Data.SqlClient.SqlCommand
Dim dataAdapter As System.Data.IDbDataAdapter = New
System.Data.SqlClient.SqlDataAdapter
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dbCommand.Connection = dbConnection
dbCommand.CommandText = "SELECT * FROM MY_TABLE"
dataAdapter.SelectCommand = dbCommand
dataAdapter.Fill(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
If I have this sequence:
Dim dbConnection As System.Data.IDbConnection = New
System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings("DB"))
Dim dbCommand As System.Data.IDbCommand = New
System.Data.SqlClient.SqlCommand
Dim dataAdapter As System.Data.IDbDataAdapter = New
System.Data.SqlClient.SqlDataAdapter
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dbCommand.Connection = dbConnection
dbCommand.CommandText = "SELECT * FROM MY_TABLE"
dataAdapter.SelectCommand = dbCommand
dataAdapter.Fill(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