关于在asp.net数据库连接字符串

Question

SqlConnection myConn = new SqlConnection(ConnString);

Answer 1

string strConn = "uid=sa;pwd=;server=(local);database=databaseName";
SqlConnection conn = new SqlConnection(strConn);

Answer 2

dim objCom as new  SqlCommand
dim dbconn as string
dbconn="server=localhost;database=GySxJJ;user id=GySxJJ;password=GySxJJ;"
objCom = New SqlClient.SqlCommand(sqlstring, New SqlClient.SqlConnection(dbconn))

Answer 3

SqlConnection conn = new SqlConnection("provider=microsoft.jet.oledb.4.0;data source="+ Server.MapPath("**.mdb") +"");

Answer 4

web.config:
    <appSettings>
<add key="ConnStr" value="server=(local);uid=sa;pwd=;database=JXC" />
    </appSettings>
VB.net:
Imports System.Configuration
Imports System.Data.SqlClient
    '连接数据库的字符串，从web.config里读取
    Public strConn As String = ConfigurationSettings.AppSettings("ConnStr")
    '定义一个全局SqlConnection 
    Public myConn As New SqlConnection(strConn)C#:
     public string strConn = ConfigurationSettings.AppSettings["strConnection"];
     public SqlConnection myConnection=new SqlConnection(strConn);

Answer 5

liujiayu10(自由自在)  :如何将连接字符串加密