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