Web. config data source configuration

1. Use ODBC to connect to the data source
Control Panel → Administrative Tools → data source ODBC → system DSN → add → drive do Microsoft Access (*. mdb) → select (example. mdb) → complete
In web. config:
<Connectionstrings>
<Add name = "connection" connectionstring = "DSN = example"/>
</Connectionstrings>
In page_load:
Odbcconnection con = new odbcconnection (configurationmanager. connectionstrings ["connection"]. connectionstring );

2. SQL Server Data Source
In web. config:
<Connectionstrings>
<Add name = "connectionsqlserver" connectionstring = "Server = (local); database = northwind; uid = sa; Pwd = sa"/>
</Connectionstrings>
In page_load:
Sqlconnection con = new sqlconnection (configurationmanager. connectionstrings ["connectionsqlserver"]. connectionstring );
Con. connectiontimeout. tostring (); // The timeout value.

3. ole db data source (ACCESS)
In web. config:
<Connectionstrings>
<Add name = "connectionoledb" connectionstring = "provider = Microsoft. Jet. oledb.4.0; Data Source = D: \ example. mdb"/>
</Connectionstrings>
In page_load:
Oledbconnection con = new oledbconnection (configurationmanager. connectionstrings ["connectionoledb"]. connectionstring );

4. oracle Data Source
the Program provided by Oracle is not. by default, the dynamic link library is introduced:
website → add reference →. net → system. data. oracleclient
Web. config:



In page_load:
oracleconnection con = new oracleconnection (configurationmanager. connectionstrings ["connectionoracle"]. connectionstring);

5. sqldatasource and accessdatasource control data source
the sqldatasource control provides three authentication modes: Windows mode, SQL Server mode, and Hybrid Authentication mode
Windows mode web. config:



SQL SERVER mode web. config:



accessdatasource is similar to sqldatasource, so it is omitted