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#