Wrox Programmer Forums
|
BOOK: Beginning ASP.NET Databases Also see the forum ASP Databases for more general discussions of ASP database issues not directly related to these books.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET Databases 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 May 20th, 2004, 09:55 AM
Registered User
 
Join Date: May 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ch3 - DataGrids display no results

For each of the examples (SQL Server, Access & Excel), the only things being displayed in browser are the <H3> contents - NO datagrid results and no errors displayed. The code is exactly as in the book and this is not a ASPNET user privilege issue within the databases.
I have been able to successfully run the SQL Server and Access pages on my home computer, but not on my work computer, so I fear that part of the problem maybe in the installation/configuration of .NET Studio 2002, NetSDK, or .NET Framework.

It appears that many other people have had problems in this section of the book.

Let me know if there is other information that I could provide in order to solve this problem.

Thanks,

Rance
 
Old May 21st, 2004, 11:22 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

Could u send ur Code, I dint have the book!

Always:),
Hovik Melkomian.
 
Old June 9th, 2004, 05:54 AM
Authorized User
 
Join Date: Nov 2003
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've been having the same problem, and I finally opened a case with Microsoft and had them look at the code. Here is their reply:

I was reviewing the code sample you sent in, and I believe you are missing only one small thing. I just added " Handles MyBase.Load" to the Page_Load declaration and it worked like a charm. Here is the declaration in the code attached to the case:

Sub Page_Load(Source As Object, E As EventArgs)

Here is the line after adding the handler:

Sub Page_Load(Source As Object, E As EventArgs) Handles MyBase.Load

Without the handler specified, the code that binds the datagrid to the datareader never runs because the program does not know that Page_Load is intended to fire on the page load event. You should be able to verify that by stepping through the code in debug mode before and after adding the handler.

Please try this and let me know the results!

Thanks,
Microsoft Developer Support

I tried it out and it works. Why Wrox hasn't identified this as errata is beyond me, but I am going to submit it now.





Similar Threads
Thread Thread Starter Forum Replies Last Post
display results carswelljr ASP.NET 2.0 Basics 1 April 19th, 2007 09:46 AM
Display Crosstab Query Results - HELP? timmaher Classic ASP Databases 0 August 25th, 2005 09:47 AM
How do I display search results... aspiretech9 PHP How-To 1 April 26th, 2005 10:12 AM
How do I display search results... aspiretech9 Beginning PHP 1 April 25th, 2005 04:59 PM
How do I display search results... aspiretech9 PHP Databases 1 April 25th, 2005 12:11 PM





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