Inserting datetime from C# to SqlServer

Question

1.00/5 (1 vote)

See more:

Hi,

I am inserting datetime from C# to SqlServer. But format is not compatible.

I tried using DateTime.Now. But it is giving error.

Please help?

Posted 15-Jul-10 9:35am

Member 7217874

Updated 19-Oct-21 19:26pm

Add a Solution

Comments

Sandeep Mewara 15-Jul-10 15:43pm

What error? What format?

Member 7217874 15-Jul-10 15:52pm

showing Incorrect Syntax error near 12.
12 is the hours.

OriginalGriff 16-Jul-10 4:25am

Answer updated.

3 solutions

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 · Answer 1 · 2010-07-15T09:51:00

Insert it with a parametrised query, and it will sort itself out - as well as being safer (see SQL Injection attack). Google SQLCommand.AddWithValue and use that instead of including the DateTime.Now in your SQL command string.

Member 7217874 wrote:
Can you give an example with entering more than one parameter insertion takes place.

SqlConnection conn = new SqlConnection("your connection string");
SqlCommand cmd = new SqlCommand("INSERT INTO table_name (username, logindate) VALUES (@USERNAME, @DATE)", conn);
cmd.Parameters.AddWithValue("@USERNAME", tbUserName.Text);
cmd.Parameters.AddWithValue("@DATE", DateTime.Now);
int i = cmd.ExecuteNonQuery();

E.msk · Answer 2 · 2010-07-15T11:09:00

ok try this
................
Sql
.............
abc datetime ,.......
abc is a columns
,......... ............
C#
......................

C#

private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string a = DateTime.Now.ToShortDateString();
                string Query = "Insert into ab values('" + a + "')";
                string con = "Data source =abc; initial catalog=ex;            integrated security= true";
                SqlConnection cn = new SqlConnection(con);
                cn.Open();
                SqlCommand cmd = new SqlCommand( Query ,cn);
                cmd.ExecuteNonQuery();
               
            }
            catch (Exception g)
            {
                label1.Text = g.Message;
            }
        }

righteous zvinairo · Answer 3 · 2021-10-19T19:26:00

Solution 6

Use GetDate() function in Sql it inserts current date

Posted 19-Oct-21 19:26pm

righteous zvinairo

Comments

CHill60 20-Oct-21 3:43am

Eleven years ago the OP wanted to pass a date from C# to SQL. GetDate() only inserts the current date - what if they are trying to store someone's date of birth? So your solution, whilst accurate, is off-topic and goes nowhere near answering the (already answered) question.
When answering questions in this forum it's best to
- stick to newer questions where the OP still needs help
- review previous solutions to make sure you're not repeating someone else's answers
- make sure you are answering the question that was asked

Sean Ewington 2-Nov-21 15:26pm

Just a reminder, answering eleven year-old questions is perfectly allowed. Unusual. Perhaps even baffling. But allowed.

CHill60 2-Nov-21 15:28pm

I do try, but thanks for the reminder

TheRealSteveJudge 20-Oct-21 5:24am

"Answering" an eleven years old question makes no sense at all.

Sean Ewington 2-Nov-21 15:26pm

Just a reminder, answering eleven year-old questions is perfectly allowed. Unusual. Perhaps even baffling. But allowed.

TheRealSteveJudge 3-Nov-21 3:08am

Hi Sean, you're right. As long as it is really a correct answer I totally agree.
This is why I put the word "answering" in quotation marks.

Inserting datetime from C# to SqlServer

3 solutions

Solution 1

Solution 3

Solution 6

Add your solution here

Preview 0