Hi,

Please can I have some advice in order to do the following?

I'm trying to develop a football 'predictions' website for my friends where a user can choose a week from a drop down and then the fixtures for that week will appear. This would contain five columns: The home team, a drop down containing 0 to 10, the away team, another drop down containing 0 to 10 and then a 'banker' checkbox (which would double points if prediction was true).

I've put together the above but unfortunately I can't work out how to insert the choices made by the user into my db. I need to insert just the goals choices, the banker choices, (eventually the users' number) and each fixture ID from my fixtures table into my predictions table.

Thanks in advance,

Dave

This is a fairly broad question with answers that vary depending on many things. What is the structure of your database? What mechanism are you using to write to the database (LINQ to SQL, calls using standard System.Data objects)? Are you using stored procedures?

What have you done so far? Have you gone through an introductory book that covers writing apps that handle data?

__________________
-Peter
compiledthoughts.com
twitter/peterlanoie

Hi,

I currently have the following tables: FixturesTable, GoalsTable, PredictionsTable, TeamsTable, WeekNoTable, SeasonTable, UserTable and HomePageText.

I managed to use the Entity Framework to bring back my home page text from a table but found it difficult to work out how to insert data using that so was then trying to use SqlDataSource. (Ideally EF as that is the future I believe).

Yes I'm trying to use Stored Procedures for everything and have these set up already in my db.

I've gone through the book "Beginning ASP.NET 4 in C# and VB" by Imar Spaanjaars (The code I'd like to learn is C#).

Thanks,

Dave

I've had a minor breakthrough

Therefore this thread can be closed.

Dave