How to configure ASP. NET Connection Database

1.Sqlserver Database Connection

1 <connectionStrings>2 <add name="Conn" connectionstring= " server=.; database=demo;uid=sa;pwd=123456 "providername="System.Data.SqlClient" />3 </connectionStrings>

2.Oracle Database Connection

1 <connectionStrings>2 <add name="Conn" connectionstring= " Provider=msdaora;data Source=demo; User Id=sa; password=123456; " providername="System.Data.OracleClient"/>3 </ Connectionstrings>

3.MYSQL Database Connection

1 <connectionStrings>2 <add name="Conn" connectionstring= " host=127.0.0.1; port=3306;database=mysql;uid=sa;pwd=12346" providername="MySql.Data.MySqlClient "/>3 </connectionStrings>

4.Acces Database Connection

1 <connectionStrings>2 <add name="Conn" connectionstring= " provider=microsoft.jet.oledb.4.0; Data source={0}app_data/demo.mdb "providername="System.Data.OleDb"/ >3 </connectionStrings>

5.SQLite Database Connection

1 <connectionStrings>2 <add name="Conn" connectionstring= " host=127.0.0.1; port=3306;database=mysql;uid=sa;pwd=12346" providername="MySql.Data.MySqlClient "/>3 </connectionStrings>

Article Source: http://www.php.cn/csharp-article-376943.html

How to configure ASP. NET Connection Database