Best Solution?

[mrathi]

Hi, Thanks for all the responses.

I have a login page. Once the user logs in correctly, he is directed to a form which has several text boxes. The values in the textboxes come from about 4 different tables. Every table will have exactly one row of data for one user. The user can change the values in textbox and save it to the database.

What is the best way to get the data from four tables when the user successfully logs in? The database is in oracle. Should I use stored procedure, if so an example will be useful? Or should I just write four sql statements in my asp.net and make four connections to the database?

Please help.

Thanks

 

[checkai]

I would probably just use an SP...

declare 4 variables
set them
return them to the app...

 

[webjunkie123]

Here are the three reasons why you should use stored procedure:
1. Performance
2. Security
3. Reliability

http://www.GeekGig.com

- The Ultimate Resource for IT Professional!