Call store procedure through SqlConnection

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

    Sub Page_Load(Sender As Object, E As EventArgs)
        Dim ConnectionString As String = _
              "server=(local)\netsdk;database=cam;trusted_connection=true"
    
        Dim CommandText As String = "AllDiscsByDate"
    
        Dim myConnection As New SqlConnection(ConnectionString)
        Dim myCommand As New SqlCommand(CommandText, myConnection)
        Dim workParam As New SqlParameter()
    
        myCommand.CommandType = CommandType.StoredProcedure
    
        myConnection.Open()
    
        DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
        DataGrid1.DataBind()
    
    End Sub

</script>
<html>
<head>
</head>
<body>
    <h2>Simple Stored Procedure </h2>
    <form runat="server">
        <asp:datagrid id="DataGrid1" runat="server" CellSpacing="1" GridLines="None" CellPadding="3" BackColor="White" ForeColor="Black" EnableViewState="False">
            <HeaderStyle font-bold="True" forecolor="white" backcolor="#4A3C8C"></HeaderStyle>
            <ItemStyle backcolor="#DEDFDE"></ItemStyle>
        </asp:datagrid>
    </form>
</body>
</html>

Related examples in the same category

1.	Retrieving Data from a Stored Procedure
2.	Call store procedure
3.	Using Stored Procedures
4.	Use stored procedure to insert data

Call store procedure through SqlConnection : Stored Procedure SqlConnection « ADO.net Database « ASP.Net

Related examples in the same category