Link to home
Start Free TrialLog in
Avatar of M.L. Martin
M.L. MartinFlag for United States of America

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.
ASKER CERTIFIED SOLUTION
Avatar of Ravi Vaddadi
Ravi Vaddadi
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of M.L. Martin

ASKER

Very, very good article offered.
Thanks appreciate  your comments