TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
sebastian
NA
1
0
Typed Dataset + DateTime-Column + NULL-Value = nowhere to go?
Oct 15 2008 9:07 AM
Hi All,
I have a problem here. I get Data from an Oracle-Database, that my application progresses. One of the columns is a DateTime-Column.
Since I need to be able to store NULL into the database for that column, I set the DataType to String in my typed dataset (otherwise I won't be able to set it to null).
Now I can pick any row and set the Value of that column to
null
, but sending the data back to oracle will result in the following error : "ORA-1830 - date format picture ends before converting entire input string". So, setting it to DataType string in the DataSet causes a mess when sending it back to oracle.
From here, I tried a lot : Setting "null" or even "'null'" as a value, but I can't seem to find a solution for this specific problem. can anyone help me with this? how the hell will i get a NULL where i need it?
thanks a lot in advance,
Reply
Answers (
1
)
Virual Map \ Map point Integration with C#
Check Box in List View get reset after Login