TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Riaz Hussain
NA
19
368
How to call SQL procedure in c# without parameters
May 13 2020 10:35 PM
I made a table whrere from I want to get sum of total days (din) group by PtR number. here is query:
ALTER
PROCEDURE
getdays
@tr_ptr nvarchar(6), @tr_din nvarchar(2), @Total
int
output
AS
BEGIN
SELECT
Total =
SUM
(
CONVERT
(
int
, tr_din))
FROM
Treatments
GROUP
BY
tr_ptr
END
I want to get sum result in my label of form by clicking the button, please guide me how to complete this job
Reply
Answers (
1
)
Write a Web API in c# to extract the data from a website
Fetch the data from external API in c#