Avatar of Rowel Virgo
Rowel VirgoFlag for Philippines

asked on 

Please HELP - SQL Stored Procedure to VB.NET

Hi,
Im using Visual Studio 2017 Community.
In the picture attached, how can I put this stored procedure from SQL to a Command Button in VB.net in a single click?
User generated image
2 Text boxes for susi() and mounter operator()
1 Button for the procedure or to call the code from the SQL stored procedure

User generated image
CREATE DEFINER=`root`@`%` PROCEDURE `proc_passmounter`(IN susi VARCHAR(32), IN operator VARCHAR(32))
BEGIN

DECLARE palletpcb VARCHAR(64);

SELECT a.palletpcbid INTO palletpcb FROM tblpcbtrace a WHERE a.pcbid = (SELECT b.pcbid FROM view_mounter_incomplete b WHERE b.palletid = susi LIMIT 1);
UPDATE tblpcbtrace SET mountertimestamp = NOW(), mounteroperator = operator , processtoken = 'mounter' WHERE palletpcbid = palletpcb;
UPDATE tblpalletinfo SET scantoken = 'mounter' WHERE palletid = susi;

END

Open in new window

Visual Basic.NETSQLMicrosoft Visual Studio

Avatar of undefined
Last Comment
Rowel Virgo
ASKER CERTIFIED SOLUTION
Avatar of Rowel Virgo
Rowel Virgo
Flag of Philippines image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Visual Basic.NET
Visual Basic.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,

96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo