读书人

OleDbDataAdapter 至少有一个参数没有

发布时间: 2012-03-06 20:47:55 作者: rapoo

OleDbDataAdapter 至少有一个参数没有指定
OleDbConnection OldConn = new OleDbConnection(连接字符串);
OldConn.Open();
DataSet Ds = new DataSet( "BBSList ");
string CommandText = "SELECT TOP 10 BBSLIst ORDER BY BBSID DESC; ";
OleDbDataAdapter OldDap = new OleDbDataAdapter(CommandText, OldConn);
OldDap.Fill(Ds, "BBSList ");
OldConn.Close();

为什么上面的语句出错。。说我至少有一个参数没有指定!


[解决办法]
OleDbConnection OldConn = new OleDbConnection(连接字符串);
OldConn.Open();
DataSet Ds = new DataSet();
string CommandText = "SELECT TOP 10 BBSLIst ORDER BY BBSID DESC; ";
OleDbDataAdapter OldDap = new OleDbDataAdapter(CommandText, OldConn);

OldDap.Fill(Ds, "BBSList ");
OldConn.Close();

读书人网 >asp.net

热点推荐