Click here to Skip to main content
11,928,403 members (57,853 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# ASP.NET LINQ C#4.0 , +
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 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 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.151126.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