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

using System.Data;
using System.Data.OleDb;

string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=C:\Northwind.mdb"; 

OleDbConnection objConnection=new OleDbConnection(strConnection);

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

......

连接SQL Server

using System.Data;
using System.Data.SqlClient;

string strConnection="user id=sa;password=;";
strConnection+="initial catalog=Northwind;Server=127.0.0.1;";
strConnection+="Connect Timeout=30";

SqlConnection objConnection=new SqlConnection(strConnection);

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