老师 请问我这段代码 怎么样用SQLfind查询出物料名称
Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.ConnectionNa me = "ces hi"
cmd.CommandText = "SE LE CT top 0 d.fname as 物料名称,b.FQty As 数量,d.FModel as 规格型号 " & _
" From POOrder a left join POOrderentry b on a.finterid = b.finterid " & _
" left join t_ICItem d on b.fitemid = d.fitemid "
dt = cmd.ExecuteReader()
Tables("窗口1_table1").DataSource= dt
Tables("窗口1_table1").DataTable.DataCols("数量").Decimals = 1
Tables("窗口1_table1").DataTable.DataCols("数量").SetFormat("0.0")
加好友 
发短信
Post By：2019/11/19 10:56:00 [只看该作者]
