用ASP.NET/C#连接Access和SQLServer数据库

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

首先看一个例子代码片断:
程序代码:

--------------------------------------------------------------------------------
usingSystem.Data;
usingSystem.Data.OleDb;

stringstrConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"DataSource=C:/BegASPNET/Northwind.mdb";

OleDbConnectionobjConnection=newOleDbConnection(strConnection);
......

objConnection.Open();
objConnection.Close();

ps:
　1."+="后面的"@"符号是防止将后面字符串中的"/"解析为转义字符.
　2.如果要连接的数据库文件和当前文件在同一个目录下,还可以使用如下的方法连接:
strConnection+="DataSource=";
strConnection+=MapPath("Northwind.mdb");
这样就可以省得你写一大堆东西了!
　3.要注意连接字符串中的参数之间要用分号来分隔.

例子代码片断:
程序代码:

--------------------------------------------------------------------------------
usingSystem.Data;
usingSystem.Data.SqlClient;

stringstrConnection="userid=sa;password=;";
strConnection+="initialcatalog=Northwind;Server=YourSQLServer;";
strConnection+="ConnectTimeout=30";

SqlConnectionobjConnection=newSqlConnection(strConnection);
...

objConnection.Open();
objConnection.Close();

共2页:上一页1

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>