Date Insert in SQL CE with internationalization

Posted by Jepe d Hepe on Stack Overflow See other posts from Stack Overflow or by Jepe d Hepe
Published on 2010-03-15T09:03:59Z Indexed on 2010/03/15 9:09 UTC
Read the original article Hit count: 168

Filed under:

sql

|

ce

|

c#.net

Before changing the regional settings of my computer. i can save a data in my application using SQL CE. when i changed my regional settings, for internationalization purpose, i can't save anymore and no error thrown when inserting data through my application. One of the fields there is a DateTime.

What might be the problem?

Thanks

Jepe

© Stack Overflow or respective owner

Related posts about sql

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Concat Function in SQL Server – SQL Concatenation

as seen on SQL Authority - Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though… >>> More
Error with SQL Server Setup 2012 on Windows 2012

as seen on Server Fault - Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: … >>> More
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? >>> More
Nested SQL Select statement fails on SQL Server 2000, ok on SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is the query: INSERT INTO @TempTable SELECT UserID, Name, Address1 = (SELECT TOP 1 [Address] FROM (SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID ORDER BY uo.AddressOrder ASC) q ORDER BY AddressOrder… >>> More

Related posts about ce

VS 2010 SP1 and SQL CE

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Last month we released the Beta of VS 2010 Service Pack 1 (SP1). You can learn more about the VS 2010 SP1 Beta from Jason Zander’s two blog posts about it, and from Scott Hanselman’s blog post that covers some of the new capabilities enabled with it. You can download and install… >>> More
Screen capture of USB connected CE device

as seen on Server Fault - Search for 'Server Fault'
Does anyone know if there's a tool to capture a video from a CE device (like this)? I used the Windows CE Remote Zoom-in to capture stills, but for presentation purposes I would like to show moving images. The devices is connected a pc using USB. I've tried using a webcam, but I have to move the… >>> More
Upgrade SQL CE 2.0 database to SQL CE 3.5 database

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anybody performed the upgrade? If yes, how is it done. I remember tinkering with running a program on command line on the PDA and that it did not work as expected. Has running the command line program on the PDA worked for anyone? Thanks >>> More
Windows CE Chat Transcript (March 30, 2010)

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
For those of you who missed the chat today, here is the raw transcript. By raw, I mean that I copied and pasted the discussion without any edits. This is divided into two parts, the top part is the answers from the Microsoft Experts and the bottom part is the questions from the audience. Answers… >>> More
Revision Control For Windows CE

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a HP Jornada 720 with Windows CE 3, called Handheld PC 2000. And as a good developer, I want to turn it into a fully-featured Scheme development environment. I already have Pocket Scheme on it, but now I need a revision control for my pocket development environment. Then I want to know: Where… >>> More