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
dipti kate
NA
23
12.5k
bind grid view using stored procedure with two queries.
Dec 2 2015 12:49 AM
I want to bind one grid view with two queries using stored procedure. for that i was written stored procedure like below:
CREATE PROCEDURE [dbo].[UserWorkDetails]
AS
BEGIN
select a1.projectName,COUNT(distinct s.SrNo)as total_count from ADDPROJECTNAMETOCRMSYSTEM a1
inner join savetodb as s
on a1.projectid=s.Projectid
inner join AssignprojectToMemberwithDetailInstruction as a2
on a2.Projectid=s.Projectid
where a2.MemberId=3
and a2.RowFNoTo<>'' and a2.RowFNorom<> ''
and s.SrNo between a2.RowFNorom and a2.RowFNoTo
group by a1.projectName
select COUNT(distinct SrNo)as Work_count from savetodb where MemberId=3
and FirstName<>'NA' and FirstName<>''
group by Projectid
End
my gridview colums like
Project Name
Total Count
Work Count
plz solve that problem as soon as possible
Reply
Answers (
1
)
newbie - getting weird returned value
How to get Feedback from users