given a team id, I need to retrieve the list of members

Question

Hi, Given a team id, i need to retrieve the list of members who are in that team.using stored procedure. please give a suggestions.

Upendra Pratap Shahi · Answer

CREATE PROCEDURE usp_GetALLTeamMembers ( @TeamID INT ) AS BEGIN SELECT m . MemberID , m . MemberName , m . MemberStatus , ml . MemberLoginName , tm . MemberJoinedDate , tm . MemberLeftDate FROM TeamMember tm INNER JOIN MemberLogin ml ON tm . MemberLoginID = ml . MemberLoginID INNER JOIN Member m ON m . MemberID = ml . MemberLoginID WHERE tm . TeamID = @TeamID END

Azeem Anzari · Answer

Of course you will get error because the return types doesn't match. You should cast the result back to teammemver type before saving that type of variable.

Sivakumar · Answer

Please give me some suggestions

Sivakumar · Answer

why iam getting error like this : my code is like below : public TeamMemberData GetAllTeamMembers(int teamid) { TeamMember getteammember = _DataContext.uspGetAllTeamMembers(teamid).SingleOrDefault(); return new TeamMemberData { TeamID = getteammember.TeamID, MemberLoginID = getteammember.MemberLoginID, MemberjoinedDate = getteammember.MemberJoinedDate }; } its shows an error : Error 1 Cannot implicitly convert type 'Kiwi.Service.DL.uspGetAllTeamMembersResult' to 'Kiwi.Service.DL.TeamMember' E:\Kiwi Project\service\Kiwi.Service.DL\DataAccess.cs 59 40 Kiwi.Service.DL please help me.

Sivakumar · Answer

public TeamMemberData GetAllTeamMembers(int teamid) { TeamMember GetTeamMember = _DataContext.usp_GetALLTeamMembers(teamid).SingleOrDefault(); return new TeamMemberData { TeamID=GetTeamMember.TeamID, MemberLoginID = GetTeamMember.MemberLoginID, MemberjoinedDate = GetTeamMember.MemberJoinedDate }; } this is my code. i get error like this : Error 1 Cannot implicitly convert type 'Kiwi.Service.DL.usp_GetALLTeamMembersResult1' to 'Kiwi.Service.DL.TeamMember' E:\Kiwi Project\service\Kiwi.Service.DL\DataAccess.cs 59 40 Kiwi.Service.DL please help me.

given a team id, I need to retrieve the list of members

Answers (5)