title: How to get a return value from a stored procedure in VB.NET
body: <p>I have a stored procedure in SQL Server for generating transaction numbers.</p>
  
  <p>Can anyone help me with how to call the Stored Procedure from VB.NET and how will i get the value that is returned from the procedure into the front end.</p>
  
  <p>Regards,
  George</p>