DataSet does not support System.Nullable<>.

Ehab Ahmed krer 0

I've this problem with my project :

asp page :

var reportParam = (dynamic)HttpContext.Current.Session["ReportParam"];
            ReportDocument rd = new ReportDocument();
            //string path = Server.MapPath("~") + "Report//Rpt//" + reportParam.RptFileName;
            string path6 = System.Web.Hosting.HostingEnvironment.MapPath("//Reports//" + reportParam.RptFileName);

            var dataSource = reportParam.DataSource;
            rd.Load(path6);
            rd.SetDataSource(dataSource);
            CrystalReportViewer1.ReportSource = rd;

Ehab Ahmed krer 0

This is mvc controller :

 public void PrntDetailRep(int? id)
        {
            ReportParam<TimeSheetViewFull_WithX> objReportParams = new ReportParam<TimeSheetViewFull_WithX>();
            objReportParams.DataSource = find_Emp_by_Id(id);
            objReportParams.RptFileName = "DetailedRep.rpt";
            this.HttpContext.Session["ReportType"] = "xxx";
            this.HttpContext.Session["ReportParam"] = objReportParams;
        }

        [HandleError]
        public List<TimeSheetViewFull_WithX> find_Emp_by_Id(int? id)
        {     
            
            var ss = db.TimeSheetViewFull_WithX.Where(x => x.ln == id).ToList();

            return (ss);
        }

Ehab Ahmed krer 0

and my java script :

<script>
    $(document).ready(function () {
        //$("#print11").click(function () {
        //    ReportManager4.LoadReport();

        //});
    });
    var Download_PdfReport = {
        DetailedReport: function (id) {
            var serviceUrl = "../DailyReport/PrntDetailRep" + "?id=" + id;
            console.log(serviceUrl);
            Download_PdfReport.GetReport1(serviceUrl);
            function OnFailed(error) {
                alert("حدث خطأ");
            }
        },

        GetReport1: function (serviceUrl, jsonParam, errorCallback) {
            jQuery.ajax({
                url: serviceUrl,
                async: false,
                type: "get",
                data: "(" + jsonParam + ")",
                contentType: "application/json; charset=utf-8",
                success: function () {
                    window.open('../RptDocView/DetailedRepFM.aspx', '_newtab');
                },
                error: errorCallback
            });
        }
    }

</script>

Ehab Ahmed krer 0

my class :

public partial class TimeSheetViewFull_WithX
    {
        public int empno { get; set; }
        public string empname { get; set; }
        public System.DateTime Mth_yr { get; set; }
        public string f1 { get; set; }
        public string f2 { get; set; }
        public string f3 { get; set; }
        public string f4 { get; set; }
        public string f5 { get; set; }
        public string f6 { get; set; }
        public string f7 { get; set; }
        public string f8 { get; set; }
        public string f9 { get; set; }
        public string f10 { get; set; }
        public string f11 { get; set; }
        public string f12 { get; set; }
        public string f13 { get; set; }
        public string f14 { get; set; }
        public string f15 { get; set; }
        public string f16 { get; set; }
        public string f17 { get; set; }
        public string f18 { get; set; }
        public string f19 { get; set; }
        public string f20 { get; set; }
        public string f21 { get; set; }
        public string f22 { get; set; }
        public string f23 { get; set; }
        public string f24 { get; set; }
        public string f25 { get; set; }
        public string f26 { get; set; }
        public string f27 { get; set; }
        public string f28 { get; set; }
        public string f29 { get; set; }
        public string f30 { get; set; }
        public string f31 { get; set; }
        public int dept_code { get; set; }
        public string lc_des_a_1 { get; set; }
        public int cc_main_cd { get; set; }
        public int cc_sub_cd { get; set; }
        public int lc_loc_area_cd { get; set; }
        public int lc_cc_area_code { get; set; }
        public int lc_loc_cd { get; set; }
        public int ln { get; set; }
        public System.DateTime? mainTotal { get; set; }
        public System.DateTime? extraTotal { get; set; }
        public int extraTotalHours { get; set; }
        public System.DateTime? extra200 { get; set; }
        public int extra200Hours { get; set; }
        public System.DateTime? extra1 { get; set; }
        public System.DateTime? extra2 { get; set; }
        public System.DateTime? extra3 { get; set; }
        public System.DateTime? extra4 { get; set; }
        public System.DateTime? extra5 { get; set; }
        public System.DateTime? extra6 { get; set; }
        public System.DateTime? extra7 { get; set; }
        public System.DateTime? extra8 { get; set; }
        public System.DateTime? extra9 { get; set; }
        public System.DateTime? extra10 { get; set; }
        public System.DateTime? extra11 { get; set; }
        public System.DateTime? extra12 { get; set; }
        public System.DateTime? extra13 { get; set; }
        public System.DateTime? extra14 { get; set; }
        public System.DateTime? extra15 { get; set; }
        public System.DateTime? extra16 { get; set; }
        public System.DateTime? extra17 { get; set; }
        public System.DateTime? extra18 { get; set; }
        public System.DateTime? extra19 { get; set; }
        public System.DateTime? extra20 { get; set; }
        public System.DateTime? extra21 { get; set; }
        public System.DateTime? extra22 { get; set; }
        public System.DateTime? extra23 { get; set; }
        public System.DateTime? extra24 { get; set; }
        public System.DateTime? extra25 { get; set; }
        public System.DateTime? extra27 { get; set; }
        public System.DateTime? extra26 { get; set; }
        public System.DateTime? extra28 { get; set; }
        public System.DateTime? extra29 { get; set; }
        public System.DateTime? extra30 { get; set; }
        public System.DateTime? extra31 { get; set; }
        public long DEP_NO { get; set; }
        public int lc_loc_id_1 { get; set; }
        public string LC_DES_A { get; set; }
        public int lc_loc_area_cd_1 { get; set; }
        public int lc_loc_cd_ { get; set; }
        public long ORG_CD_OLD { get; set; }
        public string ORG_DES { get; set; }
        public int PARENT_CD { get; set; }
        public long PARENT_CD_OLD { get; set; }
        public string HeadOfDept { get; set; }
        public int Expr1 { get; set; }
        public string tot150 { get; set; }
        public string tot200 { get; set; }
        public System.DateTime? in1 { get; set; }
        public System.DateTime? out1 { get; set; }
        public System.DateTime? in2 { get; set; }
        public System.DateTime? out2 { get; set; }
        public System.DateTime? oin3 { get; set; }
        public System.DateTime? out3 { get; set; }
        public System.DateTime? in4 { get; set; }
        public System.DateTime? out4 { get; set; }
        public System.DateTime? in5 { get; set; }
        public System.DateTime? out5 { get; set; }
        public System.DateTime? in6 { get; set; }
        public System.DateTime? out6 { get; set; }
        public System.DateTime? in7 { get; set; }
        public System.DateTime? out7 { get; set; }
        public System.DateTime? in8 { get; set; }
        public System.DateTime? out8 { get; set; }
        public System.DateTime? in9 { get; set; }
        public System.DateTime? out9 { get; set; }
        public System.DateTime? in10 { get; set; }
        public System.DateTime? out10 { get; set; }
        public System.DateTime? in11 { get; set; }
        public System.DateTime? out11 { get; set; }
        public System.DateTime? in12 { get; set; }
        public System.DateTime? out12 { get; set; }
        public System.DateTime? in13 { get; set; }
        public System.DateTime? out13 { get; set; }
        public System.DateTime? in14 { get; set; }
        public System.DateTime? out14 { get; set; }
        public System.DateTime? in15 { get; set; }
        public System.DateTime? out15 { get; set; }
        public System.DateTime? in16 { get; set; }
        public System.DateTime? out16 { get; set; }
        public System.DateTime? in17 { get; set; }
        public System.DateTime? out17 { get; set; }
        public System.DateTime? in18 { get; set; }
        public System.DateTime? out18 { get; set; }
        public System.DateTime? in19 { get; set; }
        public System.DateTime? out19 { get; set; }
        public System.DateTime? in20 { get; set; }
        public System.DateTime? out20 { get; set; }
        public System.DateTime? in21 { get; set; }
        public System.DateTime? out21 { get; set; }
        public System.DateTime? in22 { get; set; }
        public System.DateTime? out22 { get; set; }
        public System.DateTime? in23 { get; set; }
        public System.DateTime? out23 { get; set; }
        public System.DateTime? in24 { get; set; }
        public System.DateTime? out24 { get; set; }
        public System.DateTime? in25 { get; set; }
        public System.DateTime? out25 { get; set; }
        public System.DateTime? in26 { get; set; }
        public System.DateTime? out26 { get; set; }
        public System.DateTime? in27 { get; set; }
        public System.DateTime? out27 { get; set; }
        public System.DateTime? in28 { get; set; }
        public System.DateTime? out28 { get; set; }
        public System.DateTime? in29 { get; set; }
        public System.DateTime? out29 { get; set; }
        public System.DateTime? in30 { get; set; }
        public System.DateTime? out30 { get; set; }
        public System.DateTime? in31 { get; set; }
        public System.DateTime? out31 { get; set; }
    }

AgaveJoe 26,141 Reputation points

2023-05-09T13:32:07.17+00:00

There's no DataSet object in the code.
Karen Payne MVP 35,196 Reputation points

2023-05-09T23:54:19.5733333+00:00

Maybe DataColumn.AllowDBNull Property
Lan Huang-MSFT 25,866 Reputation points Microsoft Vendor

2023-05-10T08:07:09.45+00:00

Hi @Ehab Ahmed krer,

Based on the code you've provided so far, the fields you've defined are inconsistent.

1 answer

Bruce (SqlWork.com) 56,846 Reputation points

2023-05-09T16:04:49.37+00:00

the error is pretty clear. the DataSet class does not support column types of Nullable<T>. in your case System.DateTime?

In a DataSet when defining a column you use the actual type and set a property whether the column is nullable. When null, DbNull is returned for the column value.

You appear to be using a library that builds a DataSet based on POCO object types, but this library does not support Nullable<T> or it would unwrap the type and set nullable when creating the column in the DataSet.

basically your database adapter does not support nullable value types.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment