Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
rptStudyCertificate rsc = new rptStudyCertificate();
            using (DataClasseDataContext db = new DataClasseDataContext())
                var list = (from data in db.StudyCertificates
                            join clsdet in db.StudentClassDetails on data.AdmissionNo equals clsdet.AdmissionNo
                            where data.ID == Convert.ToInt16(sno)
                            select new { ID = data.ID, Class = clsdet.Class, AcademicYear = clsdet.AcademicYear, AdmissionNo = clsdet.AdmissionNo, Conduct = data.Conduct}).FirstOrDefault();

                if (list != null)
                    CrystalReportViewer1.ReportSource = rsc;
Please any one help me: i got an error at
error is: The data source object is invalid.

Thanks in advance...............
Posted 11-Jun-13 0:33am
Edited 11-Jun-13 4:27am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Siva Prakash Nammi at 11-Jun-13 6:01am
By using .ToList()

i got this error

DataSet does not support System.Nullable<>.
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

You can try debug,you can see list has data.
alternatively you can do it by dataset i think it easy than linq
Siva Prakash Nammi at 12-Jun-13 0:31am
ya it is easy using dataset, but in my whole project i am using linq queries so thats why i want to use linq in crystal reports also,...................
Thắng Cv at 12-Jun-13 3:01am
I think you must add new row

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

  Print Answers RSS
0 OriginalGriff 390
1 Jochen Arndt 165
2 Richard MacCutchan 135
3 DamithSL 95
4 Garth J Lancaster 90
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,032
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,220

Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 11 Jun 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100