Dim strsql As String ="select a.图录号,a.名称,a.作者,a.年代, a.成交价,a.买家结算状况,a.买家出帐单日期 ,a.买家付款状况,a.成交状况,a.买方付款,a.竞投牌号,a.买家对账 from httable a inner join auctionall b on a.拍卖会ID=b.拍卖会ID inner join jtdj c on a.竞投牌号=c.竞投牌号 where b.拍卖会名称 in(" & s & ") and c.姓名='" & cb1.Text & "'"
Dim i As Integer
Dim tem As String=""
Dim cmd As New SQLCommand
cmd.C
Dim dst As Table = Tables("买家结算对账_Table2")
cmd.CommandText=strsql
dst.DataSource = cmd.ExecuteReader()
dst.AutoSizeCols()
当我查询没有记录的时候 这句dst.DataSource = cmd.ExecuteReader()就报错!查询有记录的话就不报错,求解?
此主题相关图片如下:未命名.jpg
