How to save the date and time to sql server 2005

Question

0.00/5 (No votes)

See more:

I am using Vs2010 and Sql server 2005. I get date and time from user with seperated textbox. How to save it to sql server 2005 datetime column, or how to save it seperate columns date datatype and time datatype. Please help me....

Posted 16-Nov-12 22:51pm

devausha

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2012-11-16T23:19:00

Solution 1

Easy:

C#

DateTime dt = DateTime.Parse(myTextBox.Text);
using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("INSERT INTO myTable (myColumn) VALUES (@DATE)", con))
        {
        com.Parameters.AddWithValue("@DATE", dt);
        com.ExecuteNonQuery();
        }
    }

Posted 16-Nov-12 23:19pm

OriginalGriff

Comments

devausha 17-Nov-12 5:21am

I am getting date and time seperate textbox from user, So how to save it into sql server 2005.

OriginalGriff 17-Nov-12 5:32am

Concatenate the strings!
DateTime dt = DateTime.Parse(myTextBoxDate.Text + " " + myTextBoxTime.Text);

devausha 17-Nov-12 7:42am

Thank u It's Working

OriginalGriff 17-Nov-12 7:56am

You're welcome!
(But I would suggest you look at the DateTimePicker instead!)

OriginalGriff 17-Nov-12 5:33am

I wouldn't use a text box myself - have a look at the DateTimePicker instead, it's easier for the user to use, and provides a DateTime value directly. This means the user can't enter 34th Barktember 20012 or similar!