如何登录数据库？

Question

sql server:
Dim objConn As New SqlConnection()
        objConn.ConnectionString = "Data Source=Localhost; Initial Catalog=XXXX; user id=XXXX; password=XXXX;"
        objConn.Open()Access:
Dim objConn as new oledbConnection()
    objConn.connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.Mappath("XXXX")
    objConn.open()

Answer 1

C#
Access:
string strConnection"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.Mappath("XXXX");
OleDbConnection conn=new OleDbConnection(strConnection);
conn.Open();
SQL:
string strConnection = "Data Source=Localhost; Initial Catalog=XXXX; user id=XXXX; password=XXXX;"
SqlConnection conn = new SqlConnection(strConnection);
conn.Open(); //打开数据库

Answer 2

你可以在web.config 中加入:
●'web.config 连接数据库
  <appSettings>
       <add key="dsn" value="server=10.140.133.13;uid=sa;pwd=jhy; database=ydmis"></add>       
  </appSettings> 
在.vb中实例一个链接对象
dim cnn as sqlclint.sqlconnction
cnn=new sqlclint.sqlconnctint(configuation.appliSetting("dsn"))