با سلام.

store procedure زیر را ساختم:

ALTER PROCEDURE [dbo].[Repoet1]
	@datee int
AS
BEGIN
      
SELECT                   Tbl_StockSymbol.StockName, 
                         Tbl_DailySharePerformance.Price_Close, Tbl_DailySharePerformance.Increase_Decrease, Tbl_DailySharePerformance.Effective_Increase_Decrease,
						 CASE WHEN Tbl_DailySharePerformance.Effective_Increase_Decrease = 0 OR
                         Tbl_DailySharePerformance.Effective_Increase_Decrease IS NULL THEN 0 ELSE Tbl_DailySharePerformance.Increase_Decrease / Tbl_DailySharePerformance.Effective_Increase_Decrease END AS nesbateshon,
						  Tbl_DailySharePerformance.ValueOfTrade, 
                         Tbl_DailySharePerformance.Floating,
						 CASE WHEN Tbl_DailySharePerformance.Floating = 0 OR
                         Tbl_DailySharePerformance.Floating IS NULL THEN ValueOfTrade ELSE Tbl_DailySharePerformance.ValueOfTrade / Tbl_DailySharePerformance.Floating END AS nesbateshon2
FROM            Tbl_DailySharePerformance INNER JOIN
                         Tbl_StockSymbol ON Tbl_DailySharePerformance.StockCode = Tbl_StockSymbol.StockCode
WHERE        (Tbl_DailySharePerformance.PDate= @datee)

END  

آن را وارد استیمول سافت کردم.

حالا چجوری از سی شارپ ، پارامتر تاریخ رو بفرستم؟