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
Michael Le
NA
2
0
Date manipulation in expression-based columns
Jun 1 2007 2:34 PM
I want to create an expression-based column in DataSet that can do some manipulation on another DateTime column. Specifically, I have a database column named DateEnrolled. I want to create a column called ExpectedGraduationDate, which is equal to DateEnrolled + 180 (days).
I have tried to put in the Expression property of the ExpectedGraduationDate the following:
1. DateEnrolled + 180 // did not work
2. DateEnrolled.Add(180) // did not work either
Does ADO.NET expression-based columns support SQL date manipulation functions? Is there any way to work around that issue?
Reply
Answers (
1
)
Datatable.select(querry expression)
ADO vs ADO .NET and Data Transfer