Connection Strings for C#.net

Name Space For Oledb Connection

System.Data. SqlClient;

Connection strings

StrCon = “Data Source=myServerName;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;”

Name Space For Oledb Connection

Using System.Data.OleDb;

For Excel

StrCon="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+AppDomain.CurrentDomain.BaseDirectory+ "DataBase Name; Password=;";

For MySql

StrCon="Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;"

For Oracle

StrCon="Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;"

For Oracle
StrCon="Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;"