473,782 Members | 2,437 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

C#.NET: String was not recognized as a valid DateTime

31 New Member
hi,

in my web application i am getting date values from sql server database and store in the datatable.

it works fine when i use the US culture. But when i change the culture to british i am getting the error.

String was not recognized as a valid DateTime.Couldn 't store <22/02/08> in dt1 Column. Expected type is DateTime.

Any one please can help me?

i directly fill the data to the datatable by a select statement.

Thanks in Advance.

Regards,
Dhanasekaran. G
Feb 22 '08 #1
4 15338
radcaesar
759 Recognized Expert Contributor
Are you using the DatTime datatype to store the dates ?
Feb 22 '08 #2
radcaesar
759 Recognized Expert Contributor
Its seems that your problem is with the datatype in the datatable. Check that..
Feb 22 '08 #3
Plater
7,872 Recognized Expert Expert
It looks like you are trying to use a string representation to insert the value into the database. Use the DateTime object itself on inserting. (SqlParameters work well for this behaviour)
Feb 22 '08 #4
todashah
26 New Member
Hi !

In such case you have go in control panel & select Regional & Languange
Option & in that set the standard & foramat as a English(United Kingdom).
I hope its work perfectly.

Bye....Take Care,

Dhaval Shah
hi,

in my web application i am getting date values from sql server database and store in the datatable.

it works fine when i use the US culture. But when i change the culture to british i am getting the error.

String was not recognized as a valid DateTime.Couldn 't store <22/02/08> in dt1 Column. Expected type is DateTime.

Any one please can help me?

i directly fill the data to the datatable by a select statement.

Thanks in Advance.

Regards,
Dhanasekaran. G
Feb 25 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
4898
by: RSH | last post by:
I am having a bit of trouble filling a datatable with a query. I'm getting the error message: System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.DateTime.Parse(String s, IFormatProvider provider, DateTimeStyles styles) at System.DateTime.Parse(String s, IFormatProvider provider) at System.Convert.ToDateTime(String value,...
6
2503
by: Rookie Card | last post by:
I know this is a very common issue but cannot find a thread that resolves the issue. I need to re-format my dates to "MMM d, yyyy". The problem I have is I have an MSSQL database that allows <NULLS>. I'm using this code to format the dates: <%# IIF((dsCase.FieldValue("inj_beg", Container) <> nothing),DateTime.Parse(dsCase.FieldValue("inj_beg", Container)).ToString("MMM d, yyyy"), "") %>
11
33323
by: Bob Day | last post by:
The IsDate code below should result in False, instead it throws the exception below. Why? How do I check if a string can be converted to a date if this function does not work properly? Bob code: Dim blnDate_Valid As Boolean = True Dim x As String = "Hello"
1
4707
by: database | last post by:
I AM FACING A PROBLEM WHEN I ACCESS ONE OF THE PAGES. IT USED TO WORK BEFORE BUT AFTER RESTARTING THE APPLICATION SEVER IT GIVES THE FOLLOWING ERROR. - Server Error -------------------------------------------------------------------------------- The string was not recognized as a valid DateTime. There is a unknown word starting at index 20.
1
6033
by: Scott Holman | last post by:
I'm connecting to a java web service that defines the following complex type in the wsdl <xs:complexType name="employee"> <xs:sequence> <xs:element minOccurs="0" name="firstName" type="xs:string" /> <xs:element minOccurs="0" name="hireDate" type="xs:date" /> <xs:element minOccurs="0" name="lastName" type="xs:string" /> <xs:element minOccurs="0" name="terminationDate" type="xs:date" /> </xs:sequence>
10
4129
by: mercea | last post by:
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...
0
758
by: Andres Bohren | last post by:
Hi i have a GridView and have Problems to put the values into the right Datatypes. Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating Dim intID As Integer = GridView1.DataKeys(e.RowIndex).Value.ToString() Dim strDatum As String = GridView1.Rows(e.RowIndex).Cells(2).Text
1
15360
by: Magnus.Moraberg | last post by:
Hi, I have the following event which checks if a cell in a dgv contains a date and if so, checks if it is formatted correctly. I don't think its good practice for be to try this by catching an exception. Is there a better way? Notice also my use of a dummy dateTime object. Also, does the DateTime object contain any information about how it should be formatted? For example - "Format Error: DateTime cell incorrectly formatted. Expected...
3
4981
by: lucindaa | last post by:
Hi, i have a string variable having date as following format "05-01-2010" when convert this date into DateTime Format i got the following error 'String was not recognized as a valid DateTime' Please Help me to solve it
0
9479
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10146
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10080
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7492
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6733
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5509
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4043
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3639
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2874
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.