Click here to Skip to main content
15,897,187 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

SQL
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:

C#
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
Posted
Updated 25-Aug-15 19:56pm
v2
Comments
Maciej Los 26-Aug-15 1:57am    
In what line error occurs? Have you tried to debug?
PIEBALDconsult 26-Aug-15 1:58am    
Knowing the datatypes of the columns might help us.
Have you tried executing the query in SSMS or whatever tool your database uses?
Sinisa Hajnal 26-Aug-15 2:28am    
You didn't specify which columns is which type. Also, try setting a breakpoint and use step into code option.

Finally, try wrapping the code in try..catch so you get full stack info.

Good luck.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900