datetime datatype of sql server problem in windows 7

Question

0.00/5 (No votes)

See more:

hello all

i have installed windows 7 operating system.
In this OS i have installed visual studio 2008 and sql server 2005.

when i fire INSERT query with the values name,password and date field.
i am taking date from dateTimePicker ,but it gives error in datatype problem of date in sql server.

i have set datetime datatype for date field.

please help..

the error is about datatype of date field..

and the query is sqlcommand cmd=new sqlcommand("insert into tblLogin values('" + txtUName.Text + "','" + txtPass.Text + "','" + dateTimePicker.Text + "')",con);

Posted 18-Sep-11 18:53pm

yogesh89

Updated 18-Sep-11 19:10pm

v3

Add a Solution

Comments

Herman<T>.Instance 19-Sep-11 0:58am

what error is given?
what code have you written to do this?

Prerak Patel 19-Sep-11 1:09am

Show your query.

hitech_s 19-Sep-11 1:19am

is datetimepicker textbox or datetimepicker control in win applications?

if it is a control u need to use datetimepicker.value not text to get the date time

yogesh89 19-Sep-11 1:21am

datetimepicker is windows control in win applications.....

2 solutions

Solution 3

use

C#

Convert.ToDate(datepicket.value);

Posted 18-Sep-11 20:09pm

Kishore Jangid

Comments

yogesh89 20-Sep-11 6:21am

where did you get ToDate method in .Net ????

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)

hitech_s · Accepted Answer · 2011-09-18T19:21:00

Solution 1

SQL

is datetimepicker textbox or datetimepicker control in win applications?

if it is a control u need to use datetimepicker.value not text to get the date time

sorry if mis understand

Posted 18-Sep-11 19:21pm

hitech_s

Comments

yogesh89 19-Sep-11 1:27am

thnks.... it works......