如何判断数据库中符合某个条件的语句有没有记录！！加急，分高！100

[一路奔跑1314]

Dim strsql_bw3 As String
        strsql_bw3 = "select count(*) as total from tab_jdwt where nian='" & int_year & "' and yue='" & int_month & "' and wtbwdm='3'"
        Dim cmd_bw3 As New OleDbCommand(strsql_bw3, conn)
        conn.Open()
        Dim dr_bw3 As OleDbDataReader = cmd_bw3.ExecuteReader()
        dr_bw3.Read()
        If 有记录 Then
            lab_sjcs_3.Text = dr_bw3.Item("total")
        ElseIf 没有记录 Then
            lab_sjcs_3.Text = 0
        End If

        conn.Close()

请问“有记录”和“没有记录”两处的条件语句怎么写？？

[人生难得一只鸡]

直接循环读取就可以了，没有记录的话就不读取

' Always call Read before accessing data.
        While reader.Read()
            Console.WriteLine(reader.GetInt32(0) & ", " & reader.GetString(1))
        End While

[wind_cloud2011]

　　 Dim rs As OleDbDataReader = com.ExecuteReader() 　　　 While (rs.Read) s1 = rs.GetString(0) s2= rs.GetString(1) End While

[X-i-n]

oledb这块不太了解，拿你的代码试了一下，有点奇怪，你的语句是 select count ,为什么不用 dr_bw3.GetValue(0)>0？

[feiyun0112]

If int.Parse(dr_bw3.Item("total"))>0 Then

*****************************************************************************
签名档： http://feiyun0112.cnblogs.com/

[kprode]

If dr_bw3.Item("total")>0 Then lab_sjcs_3.Text = dr_bw3.Item("total") Else lab_sjcs_3.Text = 0 End If