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
djohncon
NA
16
0
Date Insertion returns incorrect date
Jan 24 2005 4:57 AM
Hi, I have a two field program to simplfy the code to find the error returned by date. The program is Window forms and the Database is MS Acess with OLEDB connection. The date 31/12/1899 is returned to the DataBase regardless of what data is entered and the format is South Pacific Date dd/MM/yyyy. I have tried every type of conversion for example : Convert, Parse, IFormatProvider, Etc. I have sample code of the insertion block: strInsert += t_ID.Text+", "; strInsert += t_Dates.Text+")"; OleDbCommand inst = new OleDbCommand(strInsert,myConn) ; //Execute the statement inst.ExecuteNonQuery() ; statusBar.Text="Data Added to Database " ; //reset all the textboxes int i=int.Parse(t_ID.Text); System.DateTime ddt = DateTime.Parse(t_Dates.Text,System.Globalization.CultureInfo.CreateSpecificCulture("en-AU").DateTimeFormat); ddt.ToString("dd/MM/yyyy"); i++; t_ID.Text=i.ToString(); t_Dates.Text = ddt.ToString("d"); t_Dates.Text = ""; statusBar.Text="Connected - Now you can Add records"; myConn.Close() ; I hope someone can help? kamean
Reply
Answers (
0
)
Talented C# Programmers Wanted.
outlook in Webservice