In the old days of Visual Studio, with apps like VB6 it used to be that you were able to declare a connection string to attach to office apps like MS Access, MS Excel and even MS Word and MS Powerpoint. Does Visual Studio 2010 still support these connection string objects for these kinds of office apps? If so, how do you create a connection string to say for instance populate a Gridview on a webform using MS Access or Excell? If that is the case, then I was just kind of wondering why you didn't use MS Access for the database of your book, especially seeing as how the SQL Server database ran inside the Visual Studio environment in the App_data folder?

Thanks once again :-)

Yes, you can. Take a look at www.connectionstrings.com

Access has no benefits over the free SQL Server Express edition, especially not for a multi-user environment such as a web app. SQL Server is more stable and reliable and the Express edition makes it easy to scale up to the commercial versions of SQL Server if you site grows.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!