Hopefully this will be made a sticky topic.

Many requests have been made for a chapter by chapter solution for this book. So you've got your request, in a manner of speaking. To get you started you can go to http://www.codeplex.com/Release/Proj...e=TheBeerHouse
and download the code.

The solutions are available chapter by chapter, from chapters 2 thru chapter 5. Unzip the file and select a chapter, then open the solution. The code is C# only, however if you download the VB code you shouldn't have a problem figuring out how to get stuff going.

I chose these chapters because each of them introduces new concepts, whereas chapters 6 thru 10 expand on the previous chapters. I have very little interest in going further, so the chances are that no other chapters will be added.

The chapter release is going to be available soon at: http://www.wrox.com/WileyCDA/WroxTit...load_code.html

Have fun!
MythicalMe

Thanks a million MythicalMe. You rock!
These chapter by chapter versions for 2-5 are now posted on Wrox.com at the book download page:
http://www.wrox.com/WileyCDA/WroxTit...load_code.html

Jim Minatel
Senior Acquisitions Editor
Wiley Technology Publishing
WROX Press
Blog: http://wroxblog.typepad.com/
Jim's Book of the week: No book this week - Donate to the Red Cross!

Wow great news
This is what we all need :)
Thanks a lot

Thanks a million MythicalMe

You can't imagine how helpful this is for me.

Keep up the good work

xrica32

For me DAL and BLL is a new subject, and I prefer to learn from VB.NET language. I'm begining tofay the chapter 4, but the final of chapter 3 is not so easy to understand in C#.

Anyone have de code from this chapters in VB.NET?
Thanks!!!

Sorry Pedro, the chances of a VB code chapter by chapter is very unlikely in the near future. It isn't a difficult chore to meld the C# chapter by chapter with the existing VB code.

Hi All, I having issues openning the solution, it is asking for the database attachment MDF file. I try to use the website configuration tool in VS2005 but I get this error.

Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.

**** I will apreciate any advise in this issue...Thanks

Marius

There are 4 solutions in the chapter by chapter code. Which one are you having trouble with?

To Marius!
Download the Microsoft SQL Server Management Studio Express



You will be prompted for Server Name
Use
YourMachineName/SQLEXPRESS
how to figure out what your MachineName SeeImage
Look for Add New DataBase Menu whithin the RightMouse Click on your server icon, or on one of the folders within the server icon.
Forget about asp_Regsql it confusing. you can make it work thru the management studio.
So remember try to look for Add a new datbase file to the server.
explore the menu. you wil find one.
Because the problem is that your sql server need to know where is your mdf file. Sql server is a little fool who is need to know where the mdf file is located. show him the the path.
I can't provide more acurate information bacause I'm sitting on the new vista now, and it will take me a few days to setup all the programms including SQLserver2005.
I hope this information will help.
thanks Antony.

I´m running win Vista but sql management studio don't recognize c:\users\Max\documents\Visual Studio Projects\websites\.......\mydb.mdf

The program don't recnogize anything there are inside c:\users\myusername


By the way... what's the best procedure?
Create db in VisualStudio and then attach db in sql management studio

or

Create db in sql management studio and attach her in visual studio?