I am using Visual Web Developer Express to develop a form in ASP.NET. I have a connection to a SQL 2000 database and within that database I have a Stored Procedure that performs a basic insert into my database (should I be using an SP for something as simply as this? There could be about 30 fields to be inserted).
How do I execute the SP within the aspx page? I have created a Sub that is culled upon a button click to execute the query but I just need a little assistance with the actual creation of the query. My connection string is defined in my web.config file and is called psybt_webInternal. Do I use this for setting up a connection to the database rather than creating a new conection?
Any assistance on this matter is greatly appreciated.