|
public partial class left : System.Web.UI.UserControl
{
OleDbConnection leftstrcon = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=c:\ypgs.mdb");
protected void Page_Load(object sender, EventArgs e)
{
try
{
string que = "select top 10 goodsID, GoodsName, SUM(price) AS dd from V_order_detail GROUP BY goodsID, GoodsName order by dd desc";
OleDbDataAdapter dap = new OleDbDataAdapter(que, leftstrcon);
DataSet daset = new DataSet();
--> dap.Fill(daset);
GridView1.DataSource = daset;
GridView1.DataBind();
string queone = "select * from tb_bbs";
OleDbDataAdapter dapone = new OleDbDataAdapter(queone, leftstrcon);
DataSet dasetone = new DataSet();
dapone.Fill(dasetone);
GridView2.DataSource = dasetone;
GridView2.DataBind();
}
finally
{
leftstrcon.Close();
}
}
编译时 出错
提示如下:
用户代码未处理 System.Data.OleDb.OleDbException
Message="至少一个参数没有被指定值。"
Source="Microsoft JET Database Engine"
ErrorCode=-2147217904
StackTrace:
在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
在 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
在 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
在 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.FillInternal(DataSet dataset, DataTable[] datatables, 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)
在 left.Page_Load(Object sender, EventArgs e) 位置 c:\Documents and Settings\Dakuai\桌面\business2\left.ascx.cs:行号 24
在 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
在 System.Web.UI.Control.OnLoad(EventArgs e)
在 System.Web.UI.Control.LoadRecursive()
在 System.Web.UI.Control.LoadRecursive()
在 System.Web.UI.Control.LoadRecursive()
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) |
|