先看一下Access的连接数据库并打开:
string
strConnection
=
"
Provider=Microsoft.Jet.OleDb.4.0;Data Source=
"
;
strConnection += Server.MapPath( " *.mdb " ); //* 就是数据库的名字
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
strConnection += Server.MapPath( " *.mdb " ); //* 就是数据库的名字
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
dim
objConnection
as
OleDbConnection
objConnection = new OleDbConnection( " Provider=Microsoft.Jet.OleDb.4.0;Data Source= " + Server.MapPath( " *.mdb " ))
objConnection.Open()
objConnection = new OleDbConnection( " Provider=Microsoft.Jet.OleDb.4.0;Data Source= " + Server.MapPath( " *.mdb " ))
objConnection.Open()
下面再看一下SQL SERVER的连接数据库并打开:
string
strConnection
=
"
server=数据库连接;uid=用户名;pwd=密码;database=数据库名字
"
;
SqlConnediob objConnection = new SqlCOnnection(strConnection);
objConnection.Open();
SqlConnediob objConnection = new SqlCOnnection(strConnection);
objConnection.Open();
dim
objConnection
as
SqlConnectiom
objConnection = new SqlConnection( " server=数据库连接;uid=用户名;pwd=密码;database=数据库名字 " )
objConnection.Open()
objConnection = new SqlConnection( " server=数据库连接;uid=用户名;pwd=密码;database=数据库名字 " )
objConnection.Open()
实际上,在大多数地方SQL SERVER和ACCESS的区别除了连接语句,其他定义语句也就是SQL××和OLEDB××的区别
另外,如果是ACCESS数据库的话在ASPX文件的开头需要包括下列语句:
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
如果是SQL SERVER则需要包括以下语句:
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>