Hi
Im trying to implement fixtures.aspx and Fixtures.aspx.cs
using the WroxUnited site( basically Im rebuilding the site for my own team Corsham RFC.

Having gone through chapters 7 & 8 Im stille perplexed as to how to apply the 1st sqldatasource as the Wroxunited sqldatasource1 (or fixturestable as its called) uses a controlparameter of FixtureDateLabel which uses the partial class in fixtures.aspx.cs to call the Slect parameter how this is done without manually coding it is beyond me at the moment.
Is ther anybody out there who could guide me through this step by step Id be much obliged
Thanks in advance
Ian

Hi,

Using the Try It Out on p249 as a base here to demo,

- Create the label control called FixtureDateLabel
- Run through steps 1 to 3 of the try it out
- In step 4, choose FixtureDate as the column, Control as the source in the left hand column, then FixtureDateLabel as the ControlID on the right. You can leave the default value blank.

At this point, you have the select statement getting information that is dependent upon the Date entered in FixtureDateLabel. And to go any further you have to do a little hand coding. Reading Chapter 9 here might give you a better idea of why its working.

- The code in Page_Load() of fixtures.aspx in the final version of WroxUnited deletes the select statement you generated earlier so that we can generate it dynamically based on today's date and whether or not you're trying to display past or future dates.
- It also sets the Text property of FixtureDateLabel to the current date to give the SELECT statement a date to work with.

So I'm afraid there isn't a way to generate the whole final page with just drag and drop, but I hope you can see that it's not too difficult to achieve with a little bit of code.

Dan

Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive

Hi Dan,
Many Thanks for the info there were quite a few settings I hadnt applied to the drag and drop stuff also the FixtureID in the DataKeyName being incorrect threw me a bit but I managed to get there over the weekend. also in doing so made a lot of other pages easier Now Im onto maybe the shop or the admin part this weekend. Thankyou for replying as it certainly helped.

Cheers
Ian

Ian,

No problems. If you have any further questions, just post it up here.

Dan

Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive