Please HELP - SQL Stored Procedure to VB.NET

Rowel Virgo
Rowel Virgo used Ask the Experts™
Im using Visual Studio 2017 Community.
In the picture attached, how can I put this stored procedure from SQL to a Command Button in in a single click?
2 Text boxes for susi() and mounter operator()
1 Button for the procedure or to call the code from the SQL stored procedure

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

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;


Open in new window

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Visual Studio .NET
I Go basic :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial