Failed convert datetime,date,time using string?

Question

I get an error about datetime,date and time.. i got 3 different datatype , mostly error all of them.. how do i get it right?

this datatype datetime: i dont know sometime i got it worked and some dont..

comu.Parameters.Add("Casedate", SqlDbType.DateTime);
comu.Parameters["Casedate"].Value = Convert.ToDateTime(TextBox1.Text);

this are datatype date only:

comu.Parameters.Add("Startdate", SqlDbType.Date);
comu.Parameters["Startdate"].Value = Convert.ToString(TextBox12.Text);

comu.Parameters.Add("Enddate", SqlDbType.Date);
comu.Parameters["Enddate"].Value = Convert.ToString(TextBox13.Text);

this are datatype time:

comu.Parameters.Add("Starttime", SqlDbType.Time);
comu.Parameters["Starttime"].Value = Convert.ToString(TextBox14.Text);

comu.Parameters.Add("Endtime", SqlDbType.Time);
comu.Parameters["Endtime"].Value = Convert.ToString(TextBox15.Text);

now i have problem on datetime, but in the last page i got it worked by put in data 11/11/2014 data in it... but now it show error on datetime back

for datetime should be dd/mm/yyyy hh:mm:ss for time should be hh:mm:ss for date should be dd/mm/yyyy @SudhakarTillapudi — user3436232
– user3436232, Commented Apr 21, 2014 at 8:10

Sudhakar Tillapudi · Accepted Answer · 2014-04-21 08:14:03Z

2

if you know the DateTime format upfront you can use DateTime.ParseExact() method to parse the given date time value properly

using System.Globalization;

DateTime dt = DateTime.ParseExact(datestring, "dd/MM/yyyy 
                                  hh:mm:ss",CultureInfo.InvariantCulture);

answered Apr 21, 2014 at 8:14

Sudhakar Tillapudi

26.3k5 gold badges43 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3436232 Over a year ago

im sorry , this are too advance for me.. idk how DateTime dt = DateTime.ParseExact(datestring, "dd/MM/yyyy hh:mm:ss",CultureInfo.InvariantCulture); goes?

Sudhakar Tillapudi Over a year ago

it parses the DateTime object from the given datetime format exactly.please check this link for more info msdn.microsoft.com/en-us/library/w2sa9yss(v=vs.110).aspx

bobthedeveloper · Accepted Answer · 2014-04-21 07:57:33Z

1

You should use the DateTime.Parse() method, you are converting a string to a string.

DateTime.Parse(TextBox1.Text)

answered Apr 21, 2014 at 7:57

bobthedeveloper

3,7832 gold badges17 silver badges31 bronze badges

Collectives™ on Stack Overflow

Failed convert datetime,date,time using string?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related