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();
}

转载于:https://www.cnblogs.com/shfranklee/archive/2005/04/20/141096.html