Dropdownlist Resetting On Post Back, ??SQL 2005 Express Database Problem

Hi all,

I am trying to write a web page connected to an sql database of my MP3 files.  I have a dropdown list box that populates with the artist,  this hopefully being used to filter results into a datagrid.  However,  i am having a problem with the ddlb box repopulating on post back,  i trawled the news groups and coded the population of the ddlb within an "if not page.postback" statement but to no avail.  If i connect the ddlb to another sql database i have,  the page reloads with the selctedvalue retained.  So the theory is now that it is the SQL database,  (is this a limitation of SQL express?) and i am having troubleshooting this.  Here is the SQL of the databse:

USE [mp3]
GO
/****** Object:  Table [dbo].[Table_1]    Script Date: 04/21/2008 20:40:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_1](
[Title] [nvarchar](50) NOT NULL,
[Artist] [nvarchar](50) NULL,
[Album] [nvarchar](50) NULL,
[Year] [nvarchar](25) NULL,
[Comment] [nvarchar](500) NULL,
[TrackNumber] [nvarchar](10) NULL,
[path] [nvarchar](300) NOT NULL,
[genre] [nvarchar](25) NULL,
[id] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK_Table_1_1] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]


Any help much appreciated.

 

Cheers

 

Billy