ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Call store procedure
<%@ Page Language=VB Debug=true %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>

Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs)
    Dim DBConn as SQLConnection
    Dim DBSP As New SQLCommand
    DBConn = New SQLConnection("server=yourhost;" _
        & "Initial Catalog=TT;" _
        & "User Id=sa;" _
        & "Password=yourpassword;")
    DBSP.CommandText = "Exec AddGarbageRecord"
    DBSP.Connection = DBConn
    DBSP.Connection.Open
    DBSP.ExecuteNonQuery()
    lblMessage.Text = "Stored procedure completed."
End Sub



Calling a Stored Procedure






    id="lblMessage"
    runat="Server"
/>