Datareader equivalent...


Author
Message
StarkMike
StarkMike
Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)
Group: Forum Members
Posts: 436, Visits: 944
Here is some of my code using a datareader... what is the strataframe equivalent to a datareader?





Using conn As New SqlConnection(ConnectionString)

Dim cmd As New SqlCommand



cmd.CommandText = StoredProcedureName

cmd.CommandType = CommandType.StoredProcedure

cmd.Connection = conn



cmd.Parameters.AddRange(params)

conn.Open()



Dim reader As SqlDataReader = cmd.ExecuteReader()



While reader.Read

msLocationName = reader("LocationName")

miLocationID = reader("LocationID")



End While



reader.Close()

reader = Nothing

conn.Close()

End Using





Thanks
Reply
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
That method will always block... the callback is used for you to provide a method that should be called if you are using Query Notification Services and the server raises the DataChanged event.  If you're not using QNS (which you probably aren't) then just pass in Nothing every time.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search