saji8282

saji8282

  • NA
  • 1
  • 0

VB.NET with MySQL Stored Procedure

Jun 28 2006 7:55 AM
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