<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Data.SqlClient" %>
Using Stored Procedures With Parameters
Enter a State Code:
Sub Submit(ByVal Source As Object, ByVal E As EventArgs)
Dim strConnection As String = ConfigurationSettings.AppSettings("NWind")
Dim objConnection As New SqlConnection(strConnection)
Dim objCommand As New SqlCommand("sp_CustomersByState", objConnection)
objCommand.CommandType = CommandType.StoredProcedure
Dim objParameter As New SqlParameter("@region", SqlDbType.NVarChar, 15)
objCommand.Parameters.Add(objParameter)
objParameter.Direction = ParameterDirection.Input
objParameter.Value = txtRegion.Text
objConnection.Open()
dgOutput.DataSource = objCommand.ExecuteReader()
dgOutput.DataBind()
objConnection.Close()
End Sub