How to connect with different types of DataBase?

Introduction

While developing Ado.Net Applicaions most of the errors comes because of the wrong format of Connection String used to connect the application with the DataBase. I am publishing some Connection String formats to connect with different types of DataBase.

Connection String Formats

To connect with the Ms-Access 2003 DataBase Connection String Format:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Full Path of the DataBase File with Extension (".Mdb");Persist Security Info=True;Jet OLEDB:Database Password=********"

To connect with the Ms-Access 2007 DataBase Connection String Format:

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Full Path of the DataBase File with Extension (".accdb");Persist Security Info=True;Jet OLEDB:Database Password=********"

To connect with the SQL Server DataBase Connection String Format:

"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DataBaseName.mdf;
Integrated Security=True;User Instance=True"

To connect with the MYSQL DataBase Connection String Format:

"DataSource=Sever Name;DataBaseName=DataBase File Name;
UserName="Name";Password=*******"

I hope this will help New developers in ADO.Net Programming.