如何从oledbdatareader检索数据 [英] how to retrieve data from oledbdatareader

问题描述

我数据库中的记录，但是当我尝试按条件检索它时，它没有显示记录...

Records in my db but when i am trying to retrieve it by where condition it shows no records...

*** Sample DBs
ID	catid	unit	price	pqty
2	1	pcc	$100.00	6
1	1	pcc	$109.00	1
2	2	fas	$44.00	3

***此处的代码

*** Code here

Dim ada As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter()
Dim cmds As OleDb.OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM salespurchase WHERE ID=" & 2, conn)
        ada.SelectCommand = cmds
                dim rdr As OleDb.OleDbDataReader = cmds.ExecuteReader

**HERE IF CONDITION DOESN'T GO INSIDE...

            If (rdr.HasRows) Then
                MsgBox("sfs")
            End If
rdr.close()

专家帮助...感谢

EXPERT HELP PLEASE...THANKS

推荐答案

100.00 6 1 1个pcc

100.00 6 1 1 pcc

109.00 1 2 2 fas

109.00 1 2 2 fas

44.00 3

***此处的代码

*** Code here

Dim ada As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter()
Dim cmds As OleDb.OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM salespurchase WHERE ID=" & 2, conn)
        ada.SelectCommand = cmds
                dim rdr As OleDb.OleDbDataReader = cmds.ExecuteReader

**HERE IF CONDITION DOESN'T GO INSIDE...

            If (rdr.HasRows) Then
                MsgBox("sfs")
            End If
rdr.close()

专家帮助...谢谢

EXPERT HELP PLEASE...THANKS

这篇关于如何从oledbdatareader检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！