error:the string was not recognized as a valid DateTime.

[mercea]

hi all, i'm trying to insert the time/date a button was clicked on a gridview and it generates an error:the string was not recognized as a valid DateTime.There is an unknown word starting at index 0 i have changed the culture to en-US but it still doesn't work. i actually created the date/time column after some data had been entered into the table so the column allows nulls. this is my code:

InsertCommand=" INSERT INTO test101(Surname ,Names,Registra tion,Date/Time)VALUES (@Surname, @Names, @Registration,@ DateTime,getdat e())"

<Insert Parameters><asp :Parameter DefaultValue= DateTime.Now() Type=DateTime Name="DateTime" /></Insert Parameters>

any suggestions?

[Plater]

You shouldn't be using DateTime.Now() but instead be using DateTime.Now, as Now is not a function.

If it doesn't like that, try DateTime.Now.To String()

[kenobewan]

Have you tried Now()? I seem to recall getDate returning the name of the day first, so depends on the design of your table.

[mercea]

You shouldn't be using DateTime.Now() but instead be using DateTime.Now, as Now is not a function.

If it doesn't like that, try DateTime.Now.To String()

now the error says "conversion failed when converting DateTime from character to string"

[Plater]

How did you name a colum "Date/Time" what is it's data type?
Have you checked the msdn on what datatypes convert to what?

[Shashi Sadasivan]

hi all, i'm trying to insert the time/date a button was clicked on a gridview and it generates an error:the string was not recognized as a valid DateTime.There is an unknown word starting at index 0 i have changed the culture to en-US but it still doesn't work. i actually created the date/time column after some data had been entered into the table so the column allows nulls. this is my code:

InsertCommand=" INSERT INTO test101(Surname ,Names,Registra tion,Date/Time)VALUES (@Surname, @Names, @Registration,@ DateTime,getdat e())"

<Insert Parameters><asp :Parameter DefaultValue= DateTime.Now() Type=DateTime Name="DateTime" /></Insert Parameters>

any suggestions?

the fields you want to be populated are surname, name, registration, date/time (4 fields)
and you are passing 5 values.... you should rather get an sql error

[mzmishra]

what is the statement @DateTime,getda te() in your sql.I guess this is creating the problem

[mercea]

hi guys, thanks for all your input. i tried all your suggestions but unfortunately non of them worked.any more?

[Plater]

If your column is really called "Date/Time" then:

InsertCommand=" INSERT INTO test101(Surname ,Names,Registra tion,Date/Time)VALUES (@Surname, @Names, @Registration,@ DateTime)"

<Insert Parameters><asp :Parameter DefaultValue= DateTime.Now Type=DateTime Name="DateTime" /></Insert Parameters>

[mercea]

If your column is really called "Date/Time" then:

InsertCommand=" INSERT INTO test101(Surname ,Names,Registra tion,Date/Time)VALUES (@Surname, @Names, @Registration,@ DateTime)"

<Insert Parameters><asp :Parameter DefaultValue= DateTime.Now Type=DateTime Name="DateTime" /></Insert Parameters>

i've tried that before and when i do that, the error is
:the string was not recognized as a valid DateTime.There is an unknown word starting at index 0

[Plater]

I dunno then. It works for me.