Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Other Programming > Need help with your homework?
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Need help with your homework? Need help with a homework question on any programming language? Post questions and help here, not in the language topic forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Need help with your homework? section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old December 4th, 2011, 11:29 AM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Question Please HELP with Website design

Hi,

I am new enough to web development, I am trying to develop a site for Horse Racing, the way I would like the site to work is as follows.

I want to display a table/list of all the days races and then select the race off the list, once the race is selected a new page loads with all the horses in the race and again I would like to be able to select a horse from this table /list and get all details on the selected horse.

I have all the necessary data in a database.

My question is what technology/features would be best used to achieve this type of design, tables populated from db with selectable fields.

Hope I have explained this sufficiently.

Thanks in advance :)

slahy
Reply With Quote
  #2 (permalink)  
Old December 5th, 2011, 05:45 AM
Authorized User
Points: 32, Level: 1
Points: 32, Level: 1 Points: 32, Level: 1 Points: 32, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

just bind a grid view to ur db table with details u want along with a column 'View' having id of race.
run a loop which will create a new imagebutton with id as that of race id and add a click event handler to these buttons with same method to be called.
ex:
for(int i=0;i<gvRace.rows.count;i++)
{
imagebutton imb=new imagebutton();
imb.id=gvRace.rows[i].cell[0].text;//or value
imb.imageUrl="";//any image u like
imb.click+=new eventhandler(imb_click);
gvRace.Rows[i].cell[0].controls.add(imb);
}

and in the click event just find the imagebutton id which is actually ur race id and pass it to next page via query string or session

protected void imb_click(object sender,ImageButtonEventAgrs e)
{
control imb=(control)sender;
server.transfer("raceDetail.aspx?rid="+imb.id);
}
Reply With Quote
  #3 (permalink)  
Old December 7th, 2011, 06:33 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

slahy,
To respond to your homework thread, I need to know more about the database, that includes the tables and their relationship. Meaning information in the horses table, how many races per day and the date or calendar table.

Also, another question, are you familiar with APEX and what is the name of your class? This will assist me in how much or detail of information to give.

Hope this helps.
__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.
Reply With Quote
  #4 (permalink)  
Old December 11th, 2011, 08:05 AM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi peace95,

sorry for the delay in getting back to you and thanks for replying, details are as follows
I have 3 tables races, horses, snapshots. The database is a MYSQL database

Races – all details about each race columns as follows

rceid, racedate, track, racetime, url1,url2,description,type,distance,furlong,class

raceid is an int it is the key for this table, racedate,track,time should all be obvious enough as to their content,
url1 and url2 are the url’s that I get all the information from these do not need to be displayed anywhere on the site.
Description (name of race), type (type of race), distance (distance in miles), furlong (distance in furlong), class(class of the race)

Horse – details about each horse columns as follows

horseid, raceid, res, cardno, draw, horsename, jockey, trainer, owner

horseid is an int it is the key for this table with raceid being the relationship between race and horse tables
res – finishing position of horse (not to be displayed anywhere) , cardno – cardno of horse, draw – stall the horse is in, horsename, jockey, trainer, owner all abvious enough.

Snapshots – contains multiple sets of bookie prices at taken at various time during the day for each horse. Columns are as follows

snapid, snaptime, snapnumber,raceid,horseid,bookieprice1,bookieprice 2,bookieprice3 ….. bookie price11.

snapid is an int it is the key for this table with raceid and horse id being the relationship to the horse and race table.
Snaptime (time snapshot was taken ), snapnumber (int between 1 – 14) bookieprice1 is the price that bookie had for the horse in question at the time of the snapshot.

There can be anything from 12 – 50 races a day, I am not familiar with APEX but if it would be the most suitable technology/language to achieve this I will start to familiarize myself with it. I have no idea what class you are referring to. Programming class ? Or something else ? I am a fast learner so don’t hold back on the details !

I would like the site to work something like this
Todays Races
racedate track racetime description type distance furlong class
Race 1 details ……………………………………
Race 2 details ……………………………………
Race 3 details ……………………………………
Race 4 details ……………………………………

Select the race you want
New page loads with the following

Race 2 ….details
cardno, draw, horsename, jockey, trainer, owner
Horse 1 details …………………………………….
Horse 2 details …………………………………….
Horse 3 details …………………………………….
Horse x details …………………………………….

Select the horse you would like and either a drop down / pop up / new page with the following

Horse name and card no
snapnumber snaptime bookieprice1 bookieprice2 bookieprice3 bookiepricex ….. ….. bookieprice11
snapshot 1 details……………………………………………
snapshot 2 details……………………………………………
snapshot 3 details……………………………………………
snapshot 4 details……………………………………………
snapshot x details……………………………………………

if you need more details please let me know.

Thanks,

slahy

Last edited by slahy; December 11th, 2011 at 08:08 AM.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
WHY only in VB:( - - - ASP.NET 3.5 Website Programming: Problem - Design - Solution g_h BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 30 October 23rd, 2009 05:11 PM
ASP.NET Website Programming: Problem - Design - So YourPhobia ASP.NET 1.0 and 1.1 Basics 0 March 5th, 2006 10:15 AM
php-mysql website - problem design solution pannet1 Pro PHP 0 December 23rd, 2005 01:49 PM
Website design spooky012017 HTML Code Clinic 2 March 16th, 2005 11:56 AM



All times are GMT -4. The time now is 09:11 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.