|
-
Mar 15th, 2004, 10:48 AM
#1
Thread Starter
Member
Thank You Fishcake!!
I have succed in retrieving information from the database. However i hope that i can pass the information to the label insead of datagrid. Can it be done by passing information from the database to the label?
Here is how i pass to the datagrid:
objCmd.commandtext = "spDateChecking"
objCmd.CommandType = CommandType.StoredProcedure
objCmd.connection = dbconn
objParam = objCmd.Parameters.Add("RETURN_VALUE", SqlDbType.Int)
objParam.Direction = ParameterDirection.ReturnValue
objCmd.Parameters.Add("@SlotDateID", weekday_value)
Dim myReader As OleDbDataReader
myReader = objCmd.ExecuteReader
If (myReader.HasRows) Then
Dim result As Integer
result = objCmd.Parameters("RETURN_VALUE").Value
dgTicketPrice.DataSource = myReader
dgTicketPrice.DataBind()
End If
'Close the connection object
dbconn.Close()
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|