Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
This is the forum to discuss the Wrox book ASP.NET 2.0 Instant Results by Imar Spaanjaars, Paul Wilton, Shawn Livermore; ISBN: 9780471749516
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old May 11th, 2012, 12:42 PM
Authorized User
Points: 222, Level: 4
Points: 222, Level: 4 Points: 222, Level: 4 Points: 222, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2007
Location: Phoenix, AZ, USA.
Posts: 48
Thanks: 4
Thanked 0 Times in 0 Posts
Default Source files for diarydb stored procedures

Hello,

I am unable to get Sql Server 2008 and Visual Studio 2008 to add the diarydb from the source download. I have created the db and associated tables, however, I still need the stored procedures. I'm wondering if the source code for these are available before I recreate the wheel from the program code.

Tom
__________________
Thomas G Magaro

Last edited by flashmanTom; May 11th, 2012 at 12:45 PM. Reason: Error in grammar
  #2 (permalink)  
Old May 12th, 2012, 06:12 AM
Imar's Avatar
Wrox Author
Points: 71,164, Level: 100
Points: 71,164, Level: 100 Points: 71,164, Level: 100 Points: 71,164, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,957
Thanks: 79
Thanked 1,556 Times in 1,533 Posts
Default

Hi there,

I don't think the code for the stored procedures is available separately. However, you can retrieve them from the database if you can attach it to SQL Server, like this:

1. Create a folder called C:\Databases and copy the DiaryDB.mdf into this folder
2. Using Windows Explorer open the Properties for this folder and on the Security tab provide full control to the Everyone account. This isn't a best practice but works well for this task.
3. Start SQL Server Management Studio and log in
4. Right-click the Databases node of your server and choose Attach
5. Browse to C:\Databases\DiaryDB.mdf
6. In the list of files at the bottom, click the row for the Log file and then click Remove. This way, the LDF will be ignored and the MDF gets attached.

That should do the trick and you should now be able to look at the procedures.

Let me know if this doesn't work for you.

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!
The Following User Says Thank You to Imar For This Useful Post:
flashmanTom (May 12th, 2012)
  #3 (permalink)  
Old May 12th, 2012, 08:48 AM
Authorized User
Points: 222, Level: 4
Points: 222, Level: 4 Points: 222, Level: 4 Points: 222, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2007
Location: Phoenix, AZ, USA.
Posts: 48
Thanks: 4
Thanked 0 Times in 0 Posts
Default

Hi Imar,

Once again, you have come through. This helps with several books where I recreated the databases for.

Many thanks,


Tom
__________________
Thomas G Magaro
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
stored procedures kirangentlebreeze1987 Visual Web Developer 2008 2 August 30th, 2010 08:26 AM
Stored Procedures umeshtheone SQL Server 2000 0 June 19th, 2007 02:08 AM
stored procedures thillaiarasu ASP.NET 2.0 Basics 2 May 3rd, 2007 08:55 AM
Stored Procedures itHighway SQL Server 2000 3 November 23rd, 2005 10:08 AM
Stored Procedures stu9820 Access 3 February 8th, 2004 01:13 PM



All times are GMT -4. The time now is 01:28 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.