Calling Stored Procedures from Visual Studio
Demonstrates using Visual tools how to call a SQL Server stored procedure from Visual Studio
Summary
Topics Covered in this Video;
-SQLDataSource
-Configure select statement
-Defining Parameters
-DataSourceSelectArguments
-Populating database
-Setting events to buttons
Video
Code
<body> <form id=”form1″ runat=”server”> <div> First Name <asp:TextBox ID=”tbFirst” runat=”server”></asp:TextBox><br /> Last Name <asp:TextBox ID=”tbLast” runat=”server”></asp:TextBox><br /> </div> <asp:Button ID=”btnSubmit” runat=”server” Text=”Submit” onclick=”btnSubmit_Click” /> <asp:SqlDataSource ID=”SqlDataSource1″ runat=”server” ConnectionString=”<%$ ConnectionStrings:RegistrationDatabaseConnectionString %>” SelectCommand=”SP_addStudent” SelectCommandType=”StoredProcedure”> <SelectParameters> <asp:ControlParameter ControlID=”tbFirst” Name=”FirstName” PropertyName=”Text” Type=”String” /> <asp:ControlParameter ControlID=”tbLast” Name=”LastName” PropertyName=”Text” Type=”String” /> </SelectParameters> </asp:SqlDataSource> <br /> </form> </body> |
Resources for Objects Used
SqlDataSource – http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.select.aspx
TextBox – http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.textbox.aspx
Button – http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.button.aspx