如何获取值VB.net?

编程入门行业动态更新时间:2024-10-27 21:15:38

本文介绍了如何获取值VB?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！问题描述

我已经编写了存储过程. 在查询分析器中执行代码声明@amt float exec ReAlto``3''，``2010''@amt输出选择@amt 上面的代码如何在VB.Net中执行请发送代码.

I have written the store procedure. Execute the code in Query Analyzer Declare @amt float exec ReAlto ''3'',''2010'' @amt output Select @amt The Above code how can execute in VB.Net Plz send the code.

CREATE PROCEDURE ReAlto @MM varchar(50), @YY varchar(50), @amt float output AS Declare @Alto float Declare @DE_Alto float if(select sum(intAltoAmt) from tblJoiningPayment where strMonth<= @MM and strYear<= @YY)=0 Begin set @Alto=0 End else Begin select @Alto= sum(intAltoAmt) from tblJoiningPayment where strMonth<= @MM and strYear<= @YY End

/***************************************************** ****************************************************** ****************************************************** ********/

/*************************************************************************************************************************************************************/

if(select sum(intPayAmount) from tblAltoPayment where strMonth<= @MM and strYear<= @YY)=0 Begin set @DE_Alto=0 End else Begin select @DE_Alto= sum(intPayAmount) from tblAltoPayment where strMonth<= @MM and strYear<= @YY End Begin Set @amt=( @Alto) - (@DE_Alto) End GO

谢谢 Mahendra Kumar Das