Click here to Skip to main content
11,702,939 members (61,066 online)
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 10-Jun-13 23:33pm
Edited 11-Jun-13 3: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 Maciej Los 415
1 Sergey Alexandrovich Kryukov 325
2 OriginalGriff 260
3 CHill60 120
4 Andy Lanng 119
0 OriginalGriff 8,379
1 Sergey Alexandrovich Kryukov 7,587
2 CPallini 4,947
3 Maciej Los 4,501
4 Mika Wendelius 3,566

Advertise | Privacy | Mobile
Web04 | 2.8.150819.1 | Last Updated 11 Jun 2013
Copyright © CodeProject, 1999-2015
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