troubleshooting Question

Please HELP - SQL Stored Procedure to VB.NET

Avatar of Rowel Virgo
Rowel VirgoFlag for Philippines asked on
Visual Basic.NETSQLMicrosoft Visual Studio
1 Comment1 Solution132 ViewsLast Modified:
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;

Rowel Virgo
Visual Studio .NET

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