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.
|
