[求助] 窗口表的SQL语句求助 Post By:2019/4/9 19:43:00 [只看该作者]
Dim tb As Table = Tables(e.Form.Name & "_Table1")
Dim tb1 As Table = Tables(e.Form.Name & "_Table11") Dim dt1 As DataTable = tb1.DataTable
Dim cmd As new SQLCommand cmd.CommandText = "sele ct DISTINCT 子阶ID,车间,组别,sum(需求数量) as 需求数量 from {" & dt1.Name & "} " MessageBox.Show(cmd.CommandText) tb.DataSource = cmd.ExecuteReader