中文字幕二区_国产精品免费在线观看_黄色网站观看_人人草人人澡_日本真实娇小xxxx

　　在asp.net中的WEB程序的設(shè)置中我們必須用到Web.config來存儲(chǔ)數(shù)據(jù)庫連接字.事實(shí)上這是個(gè)很好的做法,因?yàn)榭梢允∪ノ覀兒芏嗟穆闊┻�可以幫助我們避免不必要的錯(cuò)位,是的很多情況下我就是這樣做.它通過XML來記錄這些信息.具體的是在<appSettings>....</appSettings>這個(gè)標(biāo)記中來記錄的.這里請(qǐng)看一個(gè)ORACLE的例子如下:

代碼拷貝框
<appSettings> <add key="ORACLEConnectionString" value="Provider=OraOLEDB.Oracle.1; Persist Security Info=False;Password=blah;User ID=greg;Data Source=sph;" /> <add key="SQLConnectionString" value="data source=SQL1;initial catalog=ID_V; integrated security=SSPI;persist security info=False;workstation id=TH03D374; packet size=4096"/> <appSettings>
[Ctrl+A 全部選擇 然后拷貝]
而在你的應(yīng)用程序中你只要這樣寫,就可以了,如下:

string conn = ConfigurationSettings.AppSettings["ORACLEConnectionString"];
OleDbConnection myConnection = new OleDbConnection(conn);

很輕松是嗎?不必每次都輸入同樣的連接字,也不要記住那些討厭的信息了,只需要起一個(gè)好記的名字就可以.好了下面我在來給出其他的一些連接字:

代碼拷貝框
MYSQL的連接字: ConnectionString = "Data Source=localhost;" + "Database=mySQLDatabase;" + "User ID=myUsername;" + "Password=myPassword;" + "Command Logging=false"; OLE DB的: IBM AS/400 OLE DB 的 ' VB.NET Dim oOleDbConnection As OleDb.OleDbConnection Dim sConnString As String = _ "Provider=IBMDA400.DataSource.1;" & _ "Data source=myAS400DbName;" & _ "User Id=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() JET OLE DB 的 ' VB.NET Dim oOleDbConnection As OleDb.OleDbConnection Dim sConnString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\myPath\myJet.mdb;" & _ "User ID=Admin;" & _ "Password=" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() Oracle OLE DB 的 ' VB.NET Dim oOleDbConnection As OleDb.OleDbConnection Dim sConnString As String = _ "Provider=OraOLEDB.Oracle;" & _ "Data Source=MyOracleDB;" & _ "User ID=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() SQL Server OLE DB 的 ' VB.NET Dim oOleDbConnection As OleDb.OleDbConnection Dim sConnString As String = _ "Provider=sqloledb;" & _ "Data Source=myServerName;" & _ "Initial Catalog=myDatabaseName;" & _ "User Id=myUsername;" & _ "Password=myPassword" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() Sybase ASE OLE DB 的 ' VB.NET Dim oOleDbConnection As OleDb.OleDbConnection Dim 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) oOleDbConnection.Open() SQL Server在System.Data.SqlClient SqlConnection oSQLConn = new SqlConnection(); oSQLConn.ConnectionString = "Data Source=(local);" + "Initial Catalog=mySQLServerDBName;" + "Integrated Security=SSPI"; oSQLConn.Open();
[Ctrl+A 全部選擇 然后拷貝]
這里都是用VB.NET寫的，希望能對(duì)用VB寫ASP.NET的朋友一點(diǎn)幫助.

出處：
責(zé)任編輯：幻想曲

◎進(jìn)入論壇網(wǎng)絡(luò)編程版塊參加討論