[已解决]检查数据库查询是否返回任何值 [英] [Solved] Check if database query returned any value

问题描述

AM使用以下代码行:

AM using the following line of code:

daStreets.SelectCommand = New MySqlCommand(qryStreets, conn)           
Dim sd As MySqlCommandBuilder = New MySqlCommandBuilder(daStreets)

我如何检查是否从数据库返回了任何数据:

更新:
OP亲自解决了该问题.作为答案之一发布.

HO do i check if any data was returned from the DB:

UPDATE:
OP resolved the issue himself. Posted as one of the answer.

推荐答案

已解决:

If dsStreets.Tables("tbl_streets").Rows.Count > 0 Then
                 With cmbStreet
                     .DataSource = dsStreets.Tables("tbl_streets")
                     .DisplayMember = "streetroad"
                     .ValueMember = "id"
                     .SelectedIndex = 0
                 End With
             End If

这篇关于[已解决]检查数据库查询是否返回任何值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！