[RESOLVED] dataset or datareader?

[VBKNIGHT]

what was the best logical step and the fastest connection when i want
to get recordset from sql database.

my table name is "employee".
i have a stored procedure named "getuser" parameter is @user.

my goal is for login inform.wat to use datareader or dataset?

pls give code how to populate a dataset and or datareader

and how to compare user record value against given uservalue.

thanks in advanced! :wave:

[mendhak]

Datareader would be fastest for read-only data.

[VBKNIGHT]

how can i use sqldatareader with stored procedure

[mendhak]

Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT OrderID, CustomerID FROM Orders"
Dim myConnection As New SqlConnection(myConnString)
Dim myCommand As New SqlCommand(mySelectQuery, myConnection)
myConnection.Open()
Dim myReader As SqlDataReader
myReader = myCommand.ExecuteReader()
' Always call Read before accessing data.
While myReader.Read()
Console.WriteLine((myReader.GetInt32(0) & ", " & myReader.GetString(1)))
End While
' always call Close when done reading.
myReader.Close()
' Close the connection when done with it.
myConnection.Close()
End Sub 'ReadMyData


You can easily modify the mycommand object to work with an SP of your choice.

[mendhak]

Ah, I found an example:


Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;" & _
"Initial Catalog=northwind")

Dim salesCMD As SqlCommand = New SqlCommand("SalesByCategory", nwindConn)
salesCMD.CommandType = CommandType.StoredProcedure

Dim myParm As SqlParameter = salesCMD.Parameters.Add("@CategoryName", SqlDbType.NVarChar, 15)
myParm.Value = "Beverages"

nwindConn.Open()

Dim myReader As SqlDataReader = salesCMD.ExecuteReader()

Console.WriteLine("{0}, {1}", myReader.GetName(0), myReader.GetName(1))

Do While myReader.Read()
Console.WriteLine("{0}, ${1}", myReader.GetString(0), myReader.GetDecimal(1))
Loop

myReader.Close()
nwindConn.Close()

[mendhak]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingstoredprocedureswithcommand.asp

[VBKNIGHT]

thanks man.

[mendhak]

Wow, 5 months later. :afrog: