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
DateTime Picker Problem
Mar 3 2005 5:26 PM
Hi All, has anyone had any problems with DatetimePicker for windows and C#. I have a program with MS Access DB and two fields ID and Date. Id is a number non auto increment and primary key. Date Short date. The ID field increments by 1 to create a new record in my program. If I use a text box for date everything works fine. If I use a DateTimePicker it cause the ID to keep incrementing by 1 as if a continuing loop without even using the save button to update DB. Sample Code. protected void saveClick(object sender, System.EventArgs e) { //code to save the inputed data in to the database //no code to validate the data implemented try { if(t_ID.Text!=""&&DTP1.Text!="") { string strConn="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=Dates.mdb" ; OleDbConnection myConn = new OleDbConnection(strConn) ; myConn.Open(); //the string to get values from the textboxes and form an "INSERT INTO" // statement. string strInsert = "INSERT INTO fDate (ID, firstDate) VALUES ( "; //NOTE for integers do not have apostrophe (') in the string text strInsert += t_ID.Text+", "; System.DateTime ddt = DateTime.Parse(DTP1.Text,System.Globalization.CultureInfo.CreateSpecificCulture("en-AU").DateTimeFormat); string sNow = ""; sNow = ddt.ToString("dd/MM/yyyy"); DTP1.Text = '#'+sNow+'#'; strInsert += "CDate("+DTP1.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); i++; t_ID.Text=i.ToString(); DTP1.Text = ""; statusBar.Text="Connected - Now you can Add records"; myConn.Close() ; } else { MessageBox.Show("All fields must be completed.", "Error"); } } catch(Exception ed) { MessageBox.Show("Error in Saving "+ed.ToString(), "Error"); } } Any clues kamean
Reply
Answers (
1
)
Error with OracleClient
DataGridTableStyle problem