Pass Parameters to Stored Procedure in VB.net

Hi,

I have created the following stored Procedure for INSERTING and UPDATING data into a table.

How would i call this stored procedure form my VB.net form and pass the relevant information to it?

Here is the stored procedure:

CREATE PROCEDURE dbo.p_CreateBatchReference
(
@pre_var as INT,
@ref_id as INT,
@batch_id as INT,
@reference_1 as VARCHAR(150),
@reference_2 as VARCHAR(150),
@reference_3 as VARCHAR(150),
@reference_4 as VARCHAR(150),
@reference_5 as VARCHAR(150),
@create_date datetime
)
AS
SELECT @pre_var = COUNT(*) 
FROM tbl_reference_data
WHERE 
id = @ref_id 
/*AND reference_1 = @reference_1 
  AND reference_2 = @reference_2
  AND reference_3 = @reference_3
  AND reference_4 = @reference_4
  AND reference_5 = @reference_5
*/
IF @pre_var = 0
BEGIN
declare @date datetime
set @create_date= convert(VARCHAR, @create_date, 1) -- as dd/mm/yyyy
/* Begin with insterting new Record */
INSERT INTO tbl_reference_data (batch_id, reference_1, reference_2, reference_3, reference_4, reference_5, date_stamp)
VALUES (@batch_id, @reference_1, @reference_2, @reference_3, @reference_4, @reference_5, @create_date)
END
ELSE
BEGIN
IF @pre_var = 1
UPDATE tbl_reference_data
SET 
reference_1 = @reference_1,
reference_2 = @reference_2,
reference_3 = @reference_3,
reference_4 = @reference_4,
reference_5 = @reference_5
WHERE
id = @ref_id
END

Select all Open in new window