Connection String

"Connection String", is a Simple question strike in mind whenever someone is going to start work on Visual Studio with SQL Server.Connection String works just like a bridge to connect your application with your database.it doesn't matter, which kind of database are you using in your Server,It may be .xls or .mdb or may be .dbo .You have to just create a connection between your application and database.

For Example:

1.For .xls

strConnection = _T("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;"
bq=C:\\DatabasePath\\DBSpreadSheet.xls;DefaultDir=c:\\databasepath;");

2.For .mdb

add name="MasterSoftware.Properties.Settings.DbConnectionString"
connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Db.accdb"
providerName="System.Data.OleDb"


3.For .dbo

add name="MyConnectionString" connectionString="Data Source=my-pc;Initial Catalog=dbname;User Id=abc;Password=abc;"


The Second and most important thing is that ASP.Net provides connectivity from ADO.Net,it provides disconnected mode of connection,so that we can work virtually with our tables.

it's so simple and easy to learn these stuffs,i can explain here you later all things read continuously and carefully and feel free to clear any query.


Thanks.