insert datetime in database table field

Question

0.00/5 (No votes)

See more:

Hi,

I am trying to get the current time/date and insert it in database table but i get error.

HTML

DateTime DateTimeVariable = DateTime.Now.Date;

                       SqlConnection con1 = new SqlConnection("Data Source=MZC-RWAHDAN\\MYPROJECT2015;Persist Security Info=True;User ID=sa; Password=Fatima2010;Initial Catalog=Testing_database");

                       SqlCommand command1 = new SqlCommand("insert into TrackIt (FullName,UserName,actiontype,actiondesc,actiontime) VALUES(@param1,@param2,@param3,@param4,@param5", con1);
                      con1.Open();


                      command1.Parameters.Add(new SqlParameter("@param1", DataReader["FullName"]));
                      command1.Parameters.Add(new SqlParameter("@param2", DataReader["username"]));
                      command1.Parameters.Add(new SqlParameter("@param3", "Logged_IN"));
                      command1.Parameters.Add(new SqlParameter("@param4", "Logged in as Admin to Admin_Page"));
                      command1.Parameters.Add(new SqlParameter("@param5", DateTimeVariable));

                      command1.ExecuteNonQuery();

I am getting the full name and the username data from earlier query but the rest (3,4) i am entering text and the last one (5) i need to enter data/time for tracking. i get the error:

JavaScript

Incorrect syntax near '@param5'.

Please help,

Thanks.

Posted 18-Dec-15 19:51pm

Member 3651989

Add a Solution

Comments

Garth J Lancaster 19-Dec-15 1:57am

what is the definition for the TrackIt table - in particular the actiontime column ?

Garth J Lancaster 19-Dec-15 2:00am

btw, Im not sure about this -> DateTime DateTimeVariable = DateTime.Now.Date; ... whats wrong with DateTime.Now; (unless the column is defined as a string of course)

2 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)

deepankarbhatnagar · Accepted Answer · 2015-12-18T20:05:00

Solution 1

If you have datetime datatype in your table than insert the datetime format only thats why you are getting error. Datetime.Now will solve your problem.

Use:

C#

DateTime DateTimeVariable = DateTime.Now;

Posted 18-Dec-15 20:05pm

deepankarbhatnagar

Comments

Member 11414035 11-Jan-16 23:49pm

+5

_Asif_ · Accepted Answer · 2015-12-18T20:07:00

Solution 2

You have missed the closing bracket.

SQL

insert into TrackIt (FullName,UserName,actiontype,actiondesc,actiontime) VALUES(@param1,@param2,@param3,@param4,@param5

Correct SQL is :

SQL

insert into TrackIt (FullName,UserName,actiontype,actiondesc,actiontime) VALUES(@param1,@param2,@param3,@param4,@param5)

Fix is

C#

SqlCommand command1 = new SqlCommand("insert into TrackIt (FullName,UserName,actiontype,actiondesc,actiontime) VALUES(@param1,@param2,@param3,@param4,@param5)", con1);

Posted 18-Dec-15 20:07pm

_Asif_

Comments

Member 3651989 19-Dec-15 2:18am

i did that now i am getting a new error

String or binary data would be truncated.
The statement has been terminated.

_Asif_ 19-Dec-15 2:30am

It means that one of your column have received data larger than their allocated space.
You need to extend your column sizes and try again. Check which column have got broken