Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
John T.
Posting Yak Master
112 Posts |
 Posted - 2003-04-23 : 09:00:48
|
| I am working on my first site using SQL. I have it built using asp.net coding. Accessing an SQL 2000 db.The program is on the order of a fantasy baseball league. The users get to make choices one day, and the next day I must grade them. I am planning to make asp.net pages for myself that will allow me, via forms, to enter the results of the games. Then have the appropriate SQL queries made to update the tables accordingly, with results.I am wondering if this is the best way to do this. I have just downloaded EM and know nothing about it. One thing using a form page with the asp.net coding does is allow me to enter the data for upgrading from any computer. As long as I can log in.Any help, thanks. I really love doing this stuff. Long way to go, but really enjoy it.John |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-04-23 : 10:45:22
|
| Do you work with a DBA?Brett8-) |
 |
|
|
John T.
Posting Yak Master
112 Posts |
Posted - 2003-04-23 : 11:48:57
|
| No. I guess I am it. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-04-23 : 11:55:31
|
| Wow, a long road to hoe...I would suggest you immediatley get some books:Look herehttp://www.sqlteam.com/store.aspAnd would suggest that ALL of your code be stored in stored prcedures, using you r application layer as a presentation layer (as much as possible) only. Let the stored procedures do your heavy lifting.I'll look, but do a Forum Search on How to call a stored procedure from asp.net...Good Luck...Brett8-) |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-04-23 : 12:23:40
|
| There are good ASP.NET books that cover intro to database concepts and SQL Server as well ... WROX has some good ones; they usually have tons of examples.Maybe start with that and then get a more detailed SQL-only book after.- Jeff |
|
|
|
John T.
Posting Yak Master
112 Posts |
Posted - 2003-04-23 : 14:16:25
|
| Thanks very much. I have learned to use the sprocs as much as possible. I started out a couple months ago with knowing just a little programming. These forums have been my saving grace. This one here is the best I have come across so far. For fast and more than substantial info. I do have one WROX book already. Dynamic Websites with ASP.net. Actually, I have built this thing using the Web Matrix tool. I don't have anything to compare it with. But I seem to get things to work. Sometimes I probably look like a guy with a crowbar trying to do some heavy-duty prying. But it seems to work out. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-04-23 : 14:19:38
|
Also, there's a bunch of articles at this site as well that may be helpful(you probably already know that  ... but I often forget they are there because I usually go right to the forums !)Good luck!- Jeff |
|
|
|
|
|
|
|
|
A newbie question about updating tables