In the setting of the web program in the ASP.NET we must use Web.config to store database connection words. In fact this is
Very good practice, because you can save us a lot of troubles can also help us avoid unnecessary misplacement, there are many cases
I am doing this. It records this information through XML. The specific is in
Tagged in the mark. Please see an example of an Oracle as follows:
And you can write like this in your app, as follows:
String conn = configurationSettings.appsettings ["OracleConnectionString"]; OLEDBCONNECTION MyConnection = New OLEDBCONNECTION (CONN);
Very easy? Don't you need to enter the same connection word every time, don't remember those nasty information, just need a good book.
Name can be.
Ok, I am here to give some other connection words.
Mysql connection word: connectionString = "Data Source = localhost;" "Database = mysqldatabase;" "user ID = myusername;" "password = mypassword;" "Command logging = false"; OLE DB: IBM AS / 400 OLE DB
'VB.NETDim oOleDbConnection As OleDb.OleDbConnectionDim sConnString As String = _ "Provider = IBMDA400.DataSource.1;" & _ "Data source = myAS400DbName;" & _ "User Id = myUsername;" & _ "Password = myPassword" oOleDbConnection = New OLEDB.OLDBConnection (Sconnstring) Ooledbconnection.Open () Jet OLE DB
'Vb.netdim ooledbconnection as oledb.oledbconnectiondim sconnstring as string = _ "provider = microsoft.jet.Oledb.4.0;" & _ "data source = c: /mypath/myjet.mdb;" & _ "user ID = admin; "& _" Password = " 'VB.NETDim oOleDbConnection = New OleDb.OleDbConnection (sConnString) oOleDbConnection.Open () Oracle OLE DB of oOleDbConnection As OleDb.OleDbConnectionDim sConnString As String = _" Provider = OraOLEDB.Oracle; "& _" Data Source = Myoracledb; "& _" User ID = myusername; "& _" Password = mypassword "ooledbconnection = new oledb.oledbconnection (sconnstring) oledbconnection.open () SQL Server Ole DB
'VB.NETDim oOleDbConnection As OleDb.OleDbConnectionDim sConnString As String = _ "Provider = sqloledb;" & _ "Data Source = myServerName;" & _ "Initial Catalog = myDatabaseName;" & _ "User Id = myUsername;" & _ " Password = mypassword "ooledbconnection = new oledb.oledbconnection (sconnstring) oledbconnection.open () Sybase ASE OLE DB
VB.NETDim oOleDbConnection As OleDb.OleDbConnectionDim sConnString As String = _ "Provider = Sybase ASE OLE DB Provider;" & _ "Data Source = MyDataSourceName;" & _ "Server Name = MyServerName;" & _ "Database = MyDatabaseName;" & _ "User ID = myusername;" & _ "password = mypassword" ooledbconnection = new oledb.oledbconnection (sconnstring) oledbconnection.Open ()
SQL Server is in system.data.sqlclient
Sqlconnection osqlconn = new sqlconnection (); osqlconn.connectionstring = "data source = (local);" "Initial catalog = mysqlserdbname;" "integrated security = sspi"; osqlconn.open ();