Executing a SQL Stored Procedure from ASP WEB MATR

Jeff1218 · February 8th, 2005, 04:56 AM

I have been reading your book ASP.Net 1.1 with VB.NET 2003. I am having trouble executing stored procedures from the matrix. When I add the statement Imports SqlData.SqlClient at the top of the code page, the statement doesnot seem to fall in place. Message stating that it must come before declaratives. Can you provide some sample code for executing a stored procedure.

machicken · March 25th, 2005, 01:21 PM

first you should create a storedprocedure
after that,here is some sample:

Code:

<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Data.SqlClient" %>

<html>
  <head><title>Using Stored Procedures</title></head>
  <body>
    <form runat="server" method="post">
      <asp:DataGrid id="dgOutput" runat="server" />
    </form>
  </body>
</html>

<script language="VB" runat="server">
  Sub Page_Load(ByVal Source As Object, ByVal E As EventArgs)

  ' Connection setup
  Dim strConnection As String = ConfigurationSettings.AppSettings("NWind")
  Dim objConnection As New SqlConnection(strConnection)
  Dim objCommand As New SqlCommand( _
                   "[Ten Most Expensive Products]", objConnection)
  objCommand.CommandType = CommandType.StoredProcedure

  objConnection.Open()

  Dim objDataReader As SqlDataReader = objCommand.ExecuteReader()
  dgOutput.DataSource = objDataReader
  dgOutput.DataBind()

  objConnection.Close()
  End Sub
</script>