Sai Prasad Anumolu

Sai Prasad Anumolu

  • NA
  • 196
  • 18.9k

How To display Total Count in Label using Stored Procedure ?

Mar 4 2014 12:35 AM

This is stored Procedure .. I need , How To display total count in Webpage . Total is Display in label  ... Uing .cs code 



Create  Procedure TotalCount_Sp
As 
Begin
SELECT((Select ISNULL(SUM(Tbl_StartupBanner.Price),0) FROM Tbl_StartupBanner) +
(Select ISNULL(SUM(Tbl_SignInBanner.Price),0) FROM Tbl_SignInBanner)+
(Select ISNULL(SUM(Tbl_SignOutBanner.Price),0) FROM Tbl_SignOutBanner)+
    (Select ISNULL(SUM(Tbl_HeaderBanner.Price),0) FROM Tbl_HeaderBanner)+
    (Select ISNULL(SUM(Tbl_FooterBanner.Price),0) FROM Tbl_FooterBanner)+
    (Select ISNULL(SUM(Tbl_WebSpreadBanner.Price),0) FROM Tbl_WebSpreadBanner)
     ) as Total
End

Answers (2)