VB.NET with MySQL Stored Procedure
hi all
I have written a simple mysql stored procedure as below and i want to call this SP in my vb.net application.How to invoke this kind of MYSQL SPs in vb.net?
table ->cts_importedfile_register
Field ->IFR_Id (BIGINT, AutoIncreament)
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_Find_MaxID`
(OUT _autoid BIGINT)
BEGIN
SELECT max(IFR_Id) into _autoid FROM cts_importedfile_register;
END
hoping to get the feedback on the same ASAP
Thnx
Saajith