troubleshooting Question

Pass Parameters to Stored Procedure in VB.net

Avatar of anthonytr
anthonytrFlag for United Kingdom of Great Britain and Northern Ireland asked on
Visual Basic.NETMicrosoft SQL Server.NET Programming
1 Comment1 Solution2088 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Ganapathi
Facets Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros