I have a store procedure like following
CREATE procedure [dbo].[Sp_GetLedger]
AS
BEGIN
SELECT *,SUM(isnull(HomeCurrencyDR,0) - isnull(HomeCurrencyCR,0)) OVER (ORDER BY Voucher_No ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as Balancee
FROM ViewTransectionLedger
order by Voucher_date
END
I have shown it in grid view. But I have to know how I can set parameters from the input side for data filtering in c#