如何获取数据集中记录的条数
研究背景:做入库操作,先查询表中有没相应的记录,有则进行更新数量,没有则增加记录!(用VB.NET语言编写)
存在问题:try 与 end try 里面运行有错 ,怀疑是if语句有错原因,请大家帮忙解决一下
SearchSQL = "select count(*)from 库存 where(库存.产品ID = '" & TextBox2.Text & " ' and 库存.品牌 = '" & TextBox2.Text & " ')"
ExecuteSQL(SearchSQL, " 库存")
try
If ds.Tables(0).Rows.Count <> 0 Then
SearchSQL1 = "update 库存 set 库存.数量 = 库存.数量 + '" & TextBox5.Text & " ' where(库存.产品ID = '" & TextBox2.Text & " ' and 库存.品牌 = '" & TextBox2.Text & " ')"
ExecuteSQL(SearchSQL1, " 库存")
MsgBox("更新?", MsgBoxStyle.OKCancel + vbExclamation, "即将信息信息更新到库存中")
Else
SearchSQL2 = "insert in 库存 valus ( '" & TextBox5.Text & " ' , '" & TextBox2.Text & " ' , '" & TextBox2.Text & " ')"
ExecuteSQL(SearchSQL2, " 库存")
MsgBox("插入?", MsgBoxStyle.OKCancel + vbExclamation, "即将信息插入到库存中")
End If
Catch ex As Exception
MsgBox("入库失败 !", vbOKOnly + vbExclamation, "警告")
End Try