Hi,
I get an error like this :
An exception of type 'System.InvalidCastException' occurred in System.Data.dll but was not handled in user code
Additional information: Specified cast is not valid.
this is my table structure:
Member table having columns: MemberID,MemberName,LoginPassword,MemberStatus
MemberLogin table having columns: MemberLoginID,MemberID,MemberLoginName
Team table having columns: TeamID,TeamName,TeamStatus
TeamMember table having columns :
TeamID,MemberLoginID,MemberRole,MemberJoinedDate,MemberLeftDate
and this is my storedprocedure for getting team member details based on TeamID
ALTER PROCEDURE [dbo].[uspGetAllTeamMembers](@TeamID INT)
AS
BEGIN
SELECT
tm.TeamID,
m.MemberID,
m.MemberName,
m.MemberStatus,
ml.MemberLoginName,
ml.MemberLoginID,
tm.MemberJoinedDate,
tm.MemberLeftDate
FROM TeamMember tm
INNER JOIN MemberLogin ml
ON tm.MemberLoginID = ml.MemberLoginID
INNER JOIN Member m
ON m.MemberID = ml.MemberID
WHERE tm.TeamID = @TeamID
END
and this is my back-end code for getting TeamMember Details Based on TeamID:
public TeamMemberData GetAllTeamMembers(int teamID)
{
TeamMember getteammember = _DataContext.uspGetAllTeamMembers(teamID).SingleOrDefault();
return new TeamMemberData { TeamID=getteammember.TeamID};
}
But is shows an error
please help me