十天学会ASP.net之第五天

<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>

学习目的：学会连接两种数据库

stringstrConnection="Provider=Microsoft.Jet.OleDb.4.0;DataSource=";
strConnection+=Server.MapPath("*.mdb");//*就是数据库的名字
OleDbConnectionobjConnection=newOleDbConnection(strConnection);
objConnection.Open();
--------
dimobjConnectionasOleDbConnection
objConnection=newOleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source="+Server.MapPath("*.mdb"))
objConnection.Open()

stringstrConnection="server=数据库连接;uid=用户名;pwd=密码;database=数据库名字";
SqlConnediobobjConnection=newSqlCOnnection(strConnection);
objConnection.Open();
-----------
dimobjConnectionasSqlConnectiom＜br＞objConnection=newSqlConnection("server=数据库连接;uid=用户名;pwd=密码;database=数据库名字")
objConnection.Open()

＜%@ImportNamespace="System.Data"%＞
＜%@ImportNamespace="System.Data.OleDb"%＞

＜%@ImportNamespace="System.Data"%＞
＜%@ImportNamespace="System.Data.SqlClient"%＞

<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>