BuyLog In
Ticket Q301291
Visible to All Users

DataSet does not support System Nullable

created 14 years ago

I am following the example on this page:
http://www.devexpress.com/Support/Center/e/E1324.aspx
to add a detailed page with a drill through from a pivot grid. It used to work… then I added date and a few other columns to the grid now when I try to drill through I get an error. When I debug I get an error saying :
NotSupported Exception was unhanded by user code:
DataSet does not support System Nullable<>
The error happens on the line:
result.Columns.Add(property.Name, property.PropertyType);
where I am trying to add the date field which is nullable…
Any suggestions?
-Ken

Comments (1)
DevExpress Support Team 14 years ago

    Hello Heather,
    Thank you for your question. It appears that this question is not related directly to the ASPxPivotGrid control. Basically, the DataTable does not support the Nullable columns type. So, in this case, you can convert your data to non nullable type and create a non nullable column. Or, use another data source object to accomplish this task (E.g. IList or ITypedList ). This example only demonstrates the approach, and you are able to customize the Convert method to create any necessary data source object, according to your requirements.
    Thanks,
    Constant

    Sign in to comment on this post

    Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

    Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.