> Cannot Set
> Cannot Set Column To Be Null Please Use Dbnull Instead
Cannot Set Column To Be Null Please Use Dbnull Instead
Has this been identified as a bug that will be fixed, or do I need to log it in PITS? Having done a quick test I can confirm the behaviour above. I am currently temporarily working around this by changing the sproc to using COALESCE to replace the NULLs with 0s. I am using a Telerik.Reporting.Chart bound to a Telerik,Reporting.DataSource. useful reference
please use dbnull instead. The database field that it is boundto is an int. If I change the display member to be the same as the valuemember (both to be int), Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. C# (C sharp): The database has the correct types assigned to the fields.
Reply Post Points: 20 All Replies MichaelFrank Points 50 Replied On: Fri, Feb 12 2010 6:45 PM Reply Suggested by MichaelFrank I have a similar situation with a numeric mask: Either way, just bind the DataTable to your grid and then there's no need to transfer data manually from one to the other. 2007-2016 Why is my data not saved to Thanks, Jason Steve Admin 10941 posts Posted 16 Jul 2010 Link to this post Hello Jason, Once we have a clear view on the problem we will publish it in PITS The time now is 02:44 AM.
Why is looping over find's output bad practice? Why are LEDs in my home unaffected by voltage drop? Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Close Box Join Tek-Tips Today!
How exactly did you create the DataTable in the first place? THE ONLY "empty" value that would work for me is: System.Double.NaN. (Note that I tried several different ways of doing this, but this is the only one that would NOT flip This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL) Top Experts Last 24hrsThis month John Simmons / outlaw programmer 164 Reporting Resources Buy Try Feed for this thread 15 posts, 1 answers Jason 13 posts Member since: Aug 2012 Posted 14 Jul 2010 Link to this post Hi, The error below
By joining you are opting in to receive e-mail. http://www.telerik.com/forums/cannot-set-column-mycol-to-null-please-use-dbnull-instead Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items Deepak Shakya 118 posts Member since: Aug 2007 Posted 26 Jan 2011 Link to this Is there a way to not show these dotted lines in the chart? For databases, you specifically need to use DBNull.Value to represent a null value.
Michael Frank Reply Post Points: 5 MichaelFrank Points 50 Replied On: Fri, Feb 12 2010 7:34 PM Reply Suggested by MichaelFrank So for what it's worth. see here Please use DBNull instead.) But when I attempt to simply pass a DBNull instead, it tells me that it can't convert between DateTime and DBNull (Type of conditional expression cannot be Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert Resources Jobs Do you need your password?
Once we review it, we would be able to provide more information. Please use DBNull instead. See Trademarks or appropriate markings.
Hot Network Questions Did a thief think he could conceal his identity from security cameras by putting lemon juice on his face?
is syntax sugar for new Nullable(); which allows for null numbers, but I don't think datatables can use the nullable<> class.also be aware that data columns can be configured to either Is Area of a circle always irrational How safe is 48V DC? This is getting QUITE ridiculous, every time there is new release or even an SP, something breaks!!! Get More Info Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S.
Wrong way on a bike path? the default value of int is 0. (which is contrary to types like string and all classes whose default value is null)int? At delivery time, client criticises the lack of some features that weren't written on my quote.