Shannon,
--- shannon hall <[EMAIL PROTECTED]> wrote:
> Burak,
> Instead of a cursor it's the type of object you
> cast the returned records into. A datareader is a
> forward only set of records, it reads until the end
> and then you are done.
Can you show me how you cast the returned records
into a datareader? Do I need to add anything else to
my code below.
strSelect = "GetNumTitleUniqueFamilies"
cmdselect = New OleDbCommand(strSelect,
objConnSkills2)
cmdselect.CommandType =
CommandType.StoredProcedure
cmdselect.Parameters.Add("word",
OleDbType.VarChar).Value = strWord
cmdselect.Parameters("word").Direction =
ParameterDirection.Input
cmdselect.Parameters.Add("src",
OleDbType.VarChar).Value = strSource
cmdselect.Parameters("src").Direction =
ParameterDirection.Input
cmdselect.Parameters.Add("onetfam",
OleDbType.VarChar).Value = strOnetFamily
cmdselect.Parameters("onetfam").Direction
= ParameterDirection.Input
Dim reader As OleDbDataReader =
cmdselect.ExecuteReader()
While reader.Read()
numFamilies += 1
End While
Thanks,
Burak
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
