M.L. Martin
asked on
Code Behind Syntax when using a Stored Procedure
In the following code behind what is the difference in the syntax if using a stored procedure.
Protected Sub InsertShipper (ByVal Source As Object, ByVal e As EventArgs)
SqlDataSource1.Insert()
End Sub
The code above uses a T-SQL insert statement on an aspx page to insert a record into the database when button is clicked. I do know that the SelectCommandType on the aspx page will = Stored Procedure. However, I know the Insert of the ****SqlDataSource1.Insert( )*** above will be different but I do not know the exact code that would be needed to fire the Stored Procedure and perform the insert.. Any help or guidance is greatly appreciated.
Protected Sub InsertShipper (ByVal Source As Object, ByVal e As EventArgs)
SqlDataSource1.Insert()
End Sub
The code above uses a T-SQL insert statement on an aspx page to insert a record into the database when button is clicked. I do know that the SelectCommandType on the aspx page will = Stored Procedure. However, I know the Insert of the ****SqlDataSource1.Insert(
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very, very good article offered.
Thanks appreciate your comments
http://aspnet.4guysfromrolla.com/articles/030106-1.aspx