Question

Vb.net在access数据库中查询 显示 FROM 子句语法错误

代码如下：

'----用Repeater控件绑定显示系统动态----
Dim sql = "select top 10 * from Tch-news order by ID desc " '最新技术查询语句，返回最新10条
Dim datchNews As OleDbDataAdapter = New OleDbDataAdapter(sql, conn)
Dim dstchNews As DataSet = New DataSet()
datchNews.Fill(dstchNews)
tchRepeater.DataSource = dstchNews
tchRepeater.DataBind()
tchRepeater.Dispose()

Answer 1

表名“Tch-news ” 含减号，会导致歧义，解决办法：

1） 将表名中的减号修改为下划线，例如"Tch_news "

或者在sql语句中用方括号将表名括起来
2）Dim sql = "select top 10 * from [Tch-news] order by ID desc "