主题：怎么样取出库存数，并把它用label2显示出来，谢谢

Dim cmd As New SQLCommand
Dim dt As DataTable
Dim s1 As Integer
Dim cmb As WinForm.ComboBox
cmd.CommandText = "SELECT DISTINCT 配件名称,sum(库存) AS 库存 From {库存表} ORDER BY 编号 DESC “
s1 = cmd.ExecuteScalar

e.form.controls("Label2").text =dt

Dim cmd As New SQLCommand
cmd.CommandText = "SELECT 配件名称,sum(库存) AS 库存 From {库存表} group BY 配件名称"

e.form.controls("Label2").text =cmd.ExecuteScalar

这样不好用

看不到图

为什么不好用？