vb.net的数据库问题
各位,小妹遇到下一问题,能否帮忙一下?
下面这一数据库的语句有错不咯?
Sub gettoplist()
mysql = "select top 20 pname , sum(pcount) as scount from salerecord where state<>'0' and saledate>#" + DateTime.Now.AddMonths(-1).ToString + "# group by pname order by sum(pcount) desc "
Dim mycmd As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(mysql, mycon)
Dim dt As DataSet = New DataSet
mycmd.Fill(dt)
saletoplist.DataSource = dt
saletoplist.DataBind()
我运行的时候出现以下错误:不知道是什么原因哦.....
异常详细信息: System.Data.OleDb.OleDbException: 第 1 行: '16'
附近有语法错误。
源错误:
行 80： Dim mycmd As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(mysql, mycon)
行 81： Dim dt As DataSet = New DataSet
行 82： mycmd.Fill(dt)
行 83： saletoplist.DataSource = dt
行 84： saletoplist.DataBind() |
源文件:
D:\siewmei\mhsn\Index.aspx.vb
行: 82
堆栈跟踪:
[OleDbException (0x80040e14): 第 1 行: '16' 附近有语法错误。]
System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
System.Data.OleDb.OleDbDataReader.NextResult()
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
mhsn.Index.gettoplist() in D:\siewmei\mhsn\Index.aspx.vb:82
mhsn.Index.Page_Load(Object sender, EventArgs e) in D:\siewmei\mhsn\Index.aspx.vb:42
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
|
