Lecture – Calling Stored Procedures from Visual Studio 1

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