VB.net SQL数据库 select 查询

Question

Dim connstr As String = "Server=.;packet size=4096;Database=TCP14;User ID=sa;Password=qq88660452;Trusted_Connection=False"
Dim Conn As New SqlConnection(connstr)
Dim tbl As New DataTable
Dim da As New SqlDataAdapter("select OPEN_CELL条码,PCB条码,箱号 from LC215DT9A02 where 箱号 = '" & TextBox3.Text & "'"order by 时间, Conn)
Conn.Open()
da.Fill(tbl)
Conn.Close()
ListBox1.DataSource = tbl

求教
关键字 'from' 附近有语法错误。 谁帮我看看怎么改
还有可以用Listbox来显示吗

Answer 1

Dim da As New SqlDataAdapter("select OPEN_CELL条码,PCB条码,箱号 from LC215DT9A02 where 箱号 = '" & TextBox3.Text & "' order by 时间", Conn)

Answer 2

"select OPEN_CELL 条码,PCB条码,箱号 from LC215DT9A02 where 箱号 = '" & TextBox3.Text & "' order by 时间"