Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 2nd, 2008, 10:43 AM
Registered User
 
Join Date: Sep 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default The beerhouse project, problem with the database

I am building beerhouse application step by step. I got stuck with page managecategories.aspx. When i try to open it i get this error.

Tnx for help.



Server Error in '/Udarnik' Application.
--------------------------------------------------------------------------------

Could not find stored procedure 'tbh_Articles_GetCategories'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'tbh_Articles_GetCategories'.

Source Error:


Line 101: protected IDataReader ExecuteReader(DbCommand cmd, CommandBehavior behavior)
Line 102: {
Line 103: return cmd.ExecuteReader(behavior);
Line 104: }
Line 105:


Source File: c:\Rainspletnastran\Udarnik\App_Code\DAL\DataAcces s.cs Line: 103



 
Old September 2nd, 2008, 11:36 AM
Lee Dumond's Avatar
Wrox Author
 
Join Date: Jan 2008
Posts: 923
Thanks: 12
Thanked 166 Times in 162 Posts
Default

My suggestion would be to check your DB stored procedures, and see if tbh_Articles_GetCategories is there. If it is not, add it from the code download.

 
Old September 2nd, 2008, 01:38 PM
Registered User
 
Join Date: Sep 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

the stored procedure is there, i checked...so what could be wrong??

 
Old September 2nd, 2008, 01:48 PM
Lee Dumond's Avatar
Wrox Author
 
Join Date: Jan 2008
Posts: 923
Thanks: 12
Thanked 166 Times in 162 Posts
Default

Could be a misspelling someplace...

 
Old September 2nd, 2008, 02:50 PM
Registered User
 
Join Date: Sep 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ok. I'll try to find it. But what if it isnt, what then?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Using LINQ, with BeerHouse /Instant Result Project SoftMind BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 June 21st, 2007 03:08 AM
VS2005 database project pzmrcd Visual Studio 2005 0 January 16th, 2007 12:54 PM
connecting to a remote Access Project Database bright_mulenga Access 3 August 23rd, 2006 06:18 AM
connecting to a remote Access Project Database bright_mulenga Access 2 August 15th, 2006 06:33 AM
ASP Database Project jasmine5544 Classic ASP Databases 1 November 13th, 2003 10:23 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.