Wrox Programmer Forums
|
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution 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 August 15th, 2004, 01:51 AM
Authorized User
 
Join Date: Aug 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to macupryk Send a message via Yahoo to macupryk
Default Empty table for dropdownlist.

CREATE TABLE [dbo].[Accounts_StateCodes] (
    [Description] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [StateCode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO

The table for this is empty. Nothing is populated.

================================================== ====================================

using System;
using System.Data;

using Wrox.WebModules.Accounts.Data;

namespace Wrox.WebModules.Accounts.Data
{
    /// <summary>
    /// Summary description for AccountsTool.
    /// </summary>
    public class AccountsTool : Wrox.WebModules.Data.DbObject
    {
        public AccountsTool(string newConnectionString) : base(newConnectionString)
        { }

        public DataSet GetStateList()
        {
            return RunProcedure("sp_Accounts_GetStateList", new IDataParameter[]{}, "States");
        }
    }
}

Knowledge is to be shared.
__________________
Knowledge is to be shared.
 
Old August 15th, 2004, 08:19 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

I am not quite sure I understand why you are posting this.
Do you have a question? If so, please be more specific. Or is this related to another post??

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old August 16th, 2004, 06:33 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you just created the table, it will be empty. Did you restore the database backup file that came in the code download?

You can't create the tables by running the SQL script, as I've explained in other messages.

Eric





Similar Threads
Thread Thread Starter Forum Replies Last Post
problems to insert and into an empty table JeyZ SQL Server 2005 2 September 28th, 2007 01:36 AM
Empty rows created in Access table ayazhoda Access VBA 7 May 10th, 2007 06:23 AM
Displaying DetailsView for New/Empty Data Table Sheri B ASP.NET 2.0 Basics 5 December 7th, 2006 03:08 PM
The last empty record in table should not show alie VB Databases Basics 4 March 9th, 2006 07:38 AM
Dynamic Table calls 2 empty rows nancy Dreamweaver (all versions) 1 January 18th, 2006 06:00 PM





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