????ASP.NET??C#??????????????????SQL Server??Access???????????????????????????????梅????????????????????????????????????????????????????????????????

????????Access

??????????????????????:

???????????:

using System.Data;
using System.Data.OleDb;
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"DataSource=C:BegASPNETNorthwind.mdb";
OleDbConnection objConnection=new OleDbConnection(strConnection);
......
objConnection.Open();
objConnection.Close();
......

????????:

????????Access???????????????????????????????????????using???????????????!

????strConnection????????????????????????????????????????????????????????????????????????.

????"Provider=Microsoft.Jet.OleDb.4.0;"  2003??access ??????????????????????Microsoft Jet???妫�???Access?械????????妫琣sp.net????????Access????????????.

????"Data Source=C:BegASPNETNorthwind.mdb"????????????位??????????????"Data Source=MyDrive:MyPathMyFile.MDB".

???????

????1."+="?????"@"????????????????????械?""???????????.

????2.?????????????????????????????????锟�?????????????渭????????:

????strConnection+="Data Source=";  strConnection+=MapPath("Northwind.mdb"); ?????????????写?????????!

????3.??????????????械?????????梅???????.

????"OleDbConnection objConnection=new OleDbConnection(strConnection);"??????????????????????????????????????????????????????????????????????????.

????"objConnection.Open();"????????????.???????Access?????????????.???????(???????...)?????????榧�

????????SQL Server

??????????????:

???????????:

using System.Data;
using System.Data.SqlClient;
...
string strConnection="uid=sa;pwd=123;database=mydb;";
strConnection+="initial catalog=Northwind;Server=YourSQLServer;";
strConnection+="Connect Timeout=30";
SqlConnection objConnection=new SqlConnection(strConnection);
...
objConnection.Open();
objConnection.Close();
...

????????:

????????SQL Server???????????????Access?????????????????????????Connection???????????????械???????.

?????????????SQL Server?????????????"System.Data.OleDb"??????"System.Data.SqlClient".

?????????????????????????????????????????????(???:???????梅????):

????"user id=sa":???????????????????sa.?????????????"uid"??????????????????写??"uid=sa".

????"password=":????????????????????.????????"pwd"?????????????写?"pwd=".