Access数据库可把我难坏了(:
一个sql的小项目,成功移至Access数据库,当频繁点页面时总出错.程序是用三层,读数据库用了数据库访问类,我查了半天找不到原因,
类中代码:
public OleDbDataReader GetDataReader(string selectCmd) // Select From Table
{
OleDbConnection m_SqlConnection = new OleDbConnection(m_dbConnection);
OleDbCommand m_SqlCommand = new OleDbCommand(selectCmd, m_SqlConnection);
try
{
m_SqlCommand.Connection.Open();
} // end try
catch (Exception e)
{
throw new Exception("Error in DataBase:GetDataReader()-> " + e.ToString());
}
return m_SqlCommand.ExecuteReader(CommandBehavior.CloseConnection);
} // end Select
出错代码:
Error in CInfo:Select()-> System.Data.OleDb.OleDbException: 未指定的错误 at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at ElectWeb.CTree.Select() in D:\MyPro\ElectWeb\Components\CTree.cs:line 103
是程序的错还是access本身的错?我很少用access数据库.
请各位兄弟帮看看,up也有1-5分,挺急,这个搞定,这个项目也就完成了:)