Hi, I'm a beginner in ASP.NET programming and the project is on migrating an existing system from ASP to ASP.NET coding. I'm currently working on an Oracle database using ADO.NET and the OleDb Data Provider.
How do I save the user entries into the database; other than using stored procedures? (The user enters values into several fields and then clicks on the "Submit" button) Could I use SQL statements [eg: "INSERT INTO table_name (column_fields) VALUES (web_form_fields_values) "] instead of using stored procedures? This is because the existing system uses similar SQL statements instead of stored procedures. I've also tried searching from online resources but there are no guide material that shows how to code using stored procedures using OleDb Data Provider. What about using "Request"? Is it possible for me to save the values into the database? How do I code for a user query; other than using stored procedures? (The user enters values into several fields (criteria) and then clicks on the "Query" button to view the query results from the database) Again, could I use SQL statements instead of using stored procedures? This is because the existing system uses SQL statements instead of stored procedures. Thank you very much for your time and help in this matter. Really appreciate it a lot. ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
