ms.net中访问数据库连接 [英] ms-access database connection in asp.net

问题描述

使用ms-access连接asp.net中的数据库的步骤

及其相关编码，例如

解决方案

您的解决方案：

 string ConnectString =PROVIDER = Microsoft.Jet.OLEDB.4.0; DATA SOURCE =+ Server.MapPath（db\\\ \\database.mdb;）; 
 OleDbConnection objCon; 
 OleDbCommand objCmd; 
 DataSet Ds = new DataSet（）; 
 
 string GetSql = string.Empty; 
 GetSql =（SELECT * FROM table）; 
 using（objCon = new OleDbConnection（ConnectString））
 {
 using（objCmd = new OleDbCommand（GetSql，objCon））
 {
 OleDbDataAdapter Da = new OleDbDataAdapter（ objCmd）; 
 Da.Fill（Ds）; 
} 
} 

您还可以观看如何通过ms访问连接asp网络 [ ^ ]

Steps for connect the database in asp.net with ms-access
and their related coding with example

解决方案

Your solution:

string ConnectString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("db\\database.mdb;");
OleDbConnection objCon;
OleDbCommand objCmd;
DataSet Ds = new DataSet();

string GetSql = string.Empty;
GetSql = "(SELECT * FROM table)";
using (objCon = new OleDbConnection(ConnectString))
{
    using (objCmd = new OleDbCommand(GetSql, objCon))
    {
        OleDbDataAdapter Da = new OleDbDataAdapter(objCmd);
        Da.Fill(Ds);
    }
}

you also can watch how to connect asp net with ms access [^]

这篇关于ms.net中访问数据库连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！