In this article i will tell you how to create connection string for access database.
In the Previous articles i explained how to add asp.net membership tables to the existing database, how to get connection string from web .config file, how to create dynamic xml sitemap in asp.net, How to solve password length minimum 7 non alphanumeric characters required 1, How to apply pagination in repeater control using asp.net, How to add my website to google and many more about Asp.Net.
And Save it using file name as "string.udl". Make sure its extension is .udl.
Close this File.
Open the file you have just saved.
Go to Provider Tab. And make sure "Microsoft Jet 4.0 OLE DB Provider" is selected. Then Hit Next.
Choose your database. In my case it is "Datable.mdb".
Enter password if it is password protected else leave it blank.
Click on "Test connection" Button to make sure connection is successfully establised with database or not.
Hit OK Button.
Right Click on "string.udl" file and open it with notepad or any other text editor.
You Can see the full connection string in this file. Use it where-ever you want. Hope you learnt new thing Today.