I have a page with a bunch of controls on it.
I have added a SQL Data Source to the page which connects to an Insert stored procedure in SQL 2005 DB.
The data source gets values from controls etc ready to Insert.
I have done all of this using the GUI in Visual Studio.
What I want to know is how to I make the SP run when I click the button?
I can't use SqlDataSource1.Insert() as it's a stored procedure.
Surely this should be easy?