Radiobutton List from SQL Server Table

Hi! There must be a very simple answer to this question, but it's my first venture into using SQL Server data.

I've set up an ASP.NET site to provide for on-line sign-up of events. The site has a masterpage and utilizes a wizard to create an e-mail to request sign-up for an event.

I'd like to make my radiobuttonlist dynamic so that events past the signup deadline will not be displayed. So, I've created a database table that includes two fields: event_description and event_date – such that the radiobuttonlist will only show those events that are at least three days beyond today's date.

I've configured the data source and the radiobuttonlist so that I can display all the entries in the event table, but I can't figure out how to restrict them to today + 3 events only.

I'm guessing my problem is in the "Add Where Clause" of the "Configure Data Source" wizard. I'm sure the "Column" should be set to event_date and the "Operator" should be set to ">", but what should I set the "Source" & "Parameter Properties" to? I've set a variable in my program as "Dim deadline As Date = Today.AddDays(3)", but the wizard doesn't seem to see it.

Can anyone steer me in the right direction?

Thanks, Jerry

Try this for your where clause:

WHERE

(event_date>DATEADD(Day, 3,GETDATE()))|||

limno:

Try this for your where clause:

WHERE

(event_date>DATEADD(Day, 3,GETDATE()))

Limno,

Thanks, works like a "champ!"

From your profile, I see you're from Iowa. ...Go 'Clones!

...Jerry

|||

Hi Jerry:

I should add Ames to my profile. Have a nice day.