Larry Brister
asked on
SQL Server output in code behind
I have a SQL Server Stored procedure that has variables that need to be passed in BUT also there an out variable I have to allow for in my code behind... how do I allow for that in my VB>
SQL Server Code and VB Code
ALTER PROCEDURE [dbo].[InsertHotel]
-- Add the parameters for the stored procedure here
-- Resorts
@Name varchar(200),
@Address1 varchar(100),
@Address2 varchar(100),
blah...blah..blah...
@HotelID int output
VB Code behind...
Public Sub insertHotel()
Dim C As New clsDBConnectivity
C.dbCmnd.CommandText = "insertHotel"
C.dbCmnd.CommandType = System.Data.CommandType.St oredProced ure
C.dbCmnd.Parameters.Clear( )
C.dbCmnd.Parameters.Add(Ne w System.Data.SqlClient.SqlP arameter(" @Name", System.Data.SqlDbType.Int) ).Value = Session("custID")
C.dbCmnd.Parameters.Add(Ne w System.Data.SqlClient.SqlP arameter(" @Address1" , System.Data.SqlDbType.Int) ).Value = cmbFirm.SelectedValue
C.dbCmnd.Parameters.Add(Ne w System.Data.SqlClient.SqlP arameter(" @Address2" , System.Data.SqlDbType.NVar Char, 50)).Value = cmbStatus.SelectedValue
C.dbCmnd.Parameters.Add(Ne w System.Data.SqlClient.SqlP arameter(" @City", System.Data.SqlDbType.NVar Char, 50)).Value = Trim(txtContract.Text)
blah...blah...blah...
C.dbCmnd.Parameters.Add(Ne w System.Data.SqlClient.SqlP arameter(" @fndOtherF ee", System.Data.SqlDbType.Mone y)).Value = 0
C.dbCmnd.Parameters.Add(Ne w System.Data.SqlClient.SqlP arameter(" @fnDCalcTo tal", System.Data.SqlDbType.Mone y)).Value = ttlAmount.Text
C.dbCmnd.Parameters.Add(Ne w System.Data.SqlClient.SqlP arameter(" @UserID", System.Data.SqlDbType.Int) ).Value = Session("UserID")
Dim dr = C.dbCmnd.ExecuteReader()
dr.Read()
SQL Server Code and VB Code
ALTER PROCEDURE [dbo].[InsertHotel]
-- Add the parameters for the stored procedure here
-- Resorts
@Name varchar(200),
@Address1 varchar(100),
@Address2 varchar(100),
blah...blah..blah...
@HotelID int output
VB Code behind...
Public Sub insertHotel()
Dim C As New clsDBConnectivity
C.dbCmnd.CommandText = "insertHotel"
C.dbCmnd.CommandType = System.Data.CommandType.St
C.dbCmnd.Parameters.Clear(
C.dbCmnd.Parameters.Add(Ne
C.dbCmnd.Parameters.Add(Ne
C.dbCmnd.Parameters.Add(Ne
C.dbCmnd.Parameters.Add(Ne
blah...blah...blah...
C.dbCmnd.Parameters.Add(Ne
C.dbCmnd.Parameters.Add(Ne
C.dbCmnd.Parameters.Add(Ne
Dim dr = C.dbCmnd.ExecuteReader()
dr.Read()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.