本文介绍了一种使用ADO.NET连接并从Microsoft Access数据库中读取特定项目的详细方法。通过示例代码展示了如何建立数据库连接、执行SQL查询以及如何处理查询结果。
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();
}
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(); }
扫一扫
3997
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
