datareader problem in vb.net

Question

2.00/5 (1 vote)

See more:

hi all
i have small query like 'select top 1 from itemmaster where itemcode='XXXXX'
this above query returning 1 row from itemaster table

but when i call this same query from vb.net using sqldatareader its return 0 row, i couldn't find the solution pls give me some idea exparts

this is my code

VB

dim qry as string = 'select top 1 from itemmaster where itemcode=XXXXX' 
dim openrs1 as sqldatareader
Dim cmd As New SqlCommand(qry, myConnectionstring)
       cmd.Connection = con1
       OpenRs1 = cmd.ExecuteReader()

Posted 24-Jun-12 3:54am

sameertm

Updated 24-Jun-12 4:05am

v2

Add a Solution

Comments

OriginalGriff 24-Jun-12 9:57am

Show the code!
Use the "Improve question" widget to edit your question and provide better information.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-06-24T06:05:00

Even after updating question with code snippet, it looks incomplete and does not makes much sense on what you say.

Look here on how to use DataReader to fetch data from database:

VB

Using connection
        Dim command As SqlCommand = New SqlCommand( _
          "SELECT CategoryID, CategoryName FROM Categories;", _
          connection)
        connection.Open()

        Dim reader As SqlDataReader = command.ExecuteReader()

        If reader.HasRows Then
            Do While reader.Read()
                Console.WriteLine(reader.GetInt32(0) _
                  & vbTab & reader.GetString(1))
            Loop
        Else
            Console.WriteLine("No rows found.")
        End If

        reader.Close()
    End Using

Refer:
Retrieving Data Using a DataReader (ADO.NET)[^]
DataReader Class[^]

datareader problem in vb.net

1 solution

Solution 1

Add your solution here

Preview 0

datareader problem in vb.net

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us