StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Datareader equivalent...

Datareader equivalent...

StarkMike — Thu, 12 Oct 2006 15:00:41 GMT

Here is some of my code using a datareader... what is the strataframe equivalent to a datareader?

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

Thanks

RE: Datareader equivalent...

StarkMike — Thu, 12 Oct 2006 15:00:41 GMT

Thanks Guys! :D

RE: Datareader equivalent...

StrataFrame Team — Thu, 12 Oct 2006 14:58:31 GMT

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.

RE: Datareader equivalent...

Trent L. Taylor — Thu, 12 Oct 2006 14:52:39 GMT

Nothing will work fine if you do not want to execute this asynchronously and invoke a callback method when it is completed. By providing the nothing it will just block until the method has completed executing.

RE: Datareader equivalent...

StarkMike — Thu, 12 Oct 2006 14:26:26 GMT

Hey Ben,

Based on the code you provided in your last post I put this piece of code together

[code] Dim dtbl As DataTable = DataBasics.DataSources("").GetDataTable(cmd, Nothing) [/code]

Which works and does what i want it to... the only question I have is what am i supposed to provide for the [b] ByVal CallBack As System.Data.SqlClient.OnChangeEventHandler [/b] argument? I put [i] Nothing [/i] and it works I'm just not sure if thats what I'm supposed to put there. :hehe:

RE: Datareader equivalent...

StrataFrame Team — Tue, 10 Oct 2006 09:09:00 GMT

Everything in StrataFrame is disconnected data, but ADO.NET has a DataTableReader that operates in the same fashion as the DbDataReader (by implementing the IDataReader interface). So, if you wanted to create a "reader" you would do this (from within a business object):

Public Function GetReader() As DbDataReader
'-- Execute the statement and return a new reader
Return New DataTableReader(Me.GetDataTable("SELECT TOP 100 * FROM Customers"))
End Function