ASP.NET + C#读取ACCESS数据库内容的简单方法

ASP.NET+C#读取ACCESS数据库的简单方法之一。代码如下：

string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Database/TeamPro.mdb");
string strSQL = "SELECT * FROM Project where id=" + Convert.ToInt32(Request.QueryString["Project_ID"]) ;

// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbCommand myCmd = new OleDbCommand( strSQL, myConn );
OleDbDataReader datareader = null;
try
{
myConn.Open();
datareader = myCmd.ExecuteReader();
while (datareader.Read() )
{
ProjectName.Text=datareader["Project_Name"].ToString();
ProjectManager.Text=datareader["Project_Manager"].ToString();
ProjectStatus.Text=datareader["Project_Status"].ToString();
ProjectDescription.Text=datareader["Project_Description"].ToString();
ProjectObjective.Text=datareader["Project_Objective"].ToString();
CreateDate.Text=datareader["Create_Date"].ToString();
}
}
catch (Exception e)
{
string Messate = e.Message;
}
finally
{
myConn.Close();
}