ArgumentOutOfRangeException when using DataTable.WriteXML
Thu, 01 May 2008 15:18:42 -0500
Hi, All!
I'm having a strange issue with DataTable.WriteXML. I've created a database with
19 tables using an XML file that I read and process manually. Here is an excerpt
from the table in question:
<Loads PrimaryKey="OrderNumber,Segment">
<Field Name="OrderNumber" Type="nvarchar" Size="30" />
...
|
Master/Detail Navigator issues
Thu, 1 May 2008 11:47:06 -0700
I have spent many hours on this and have not found a way to have a
Master/Detail or Parent/Child table work with the child having the correct
identity value passed. I built two tests projects one with SQLCE and the
other with SQL Express 2005. The SQL Express 2005 worked without a flaw.
The same code did ...
|
3.1 to 3.5 Upgrade
Wed, 30 Apr 2008 13:36:06 -0700
Is it possible to upgrade a SQL CE 3.1 database to 3.5 in Windows CE 5.0? I
see that SqlCeEngine has a method called Upgrade, but every time I call it it
throws an exception with this error message:
The specified module could not be found
I was thinking this would be because it can't find some file(s), bu ...
|
HELP: Baffled by bug (?) in SqlCeCommand:
Mon, 28 Apr 2008 10:00:16 -0700
I am getting strange results running a SqlCeCommand (v3.1) in a .NET
application.
It is a select command, and the bug (?) depends on the first time the
command is used to retrieve results.
If the table is entirely empty, then for the rest of the lifetime of the
SqlCeCommand, the WHERE clause is ignored ...
|
SQLServerCE 3.1 and Vista Ultimate
Wed, 23 Apr 2008 19:47:22 -0500
I've been struggling to get the prerequisites correct for some time now.
What I have:
I have Visual Studio 2005 Professional
Express editions of VS do not suit my needs
I have Vista Ultimate 64 bit as my OS, on my development machine
What I need:
To embed a SQL database within my app ...
|
Can't drop table because "The system timed out waiting for a locK".
Wed, 23 Apr 2008 14:42:41 -0400
Hello,
I'm using VS2005 (vb.net) and sql ce compact edition (3.0).
This app. had been working in the past, but a new issue has popped up.
Normally what is supposed to happen is, from the device (using RDA), I push
the data to the server , drop the table, then repull the data from the
server. This had ...
|
custom insert for databound datagridview
Wed, 23 Apr 2008 11:41:06 -0700
I don't know if this is the right forum to post this in, but I will start
here....
I am writing a desktop database application. I created a simple SQL CE
database. I then created a new form and dragged the DataGridView control from
the toolbox to the form.
I then created a new data source and pointed it ...
|
|
|
VS2008 and Compact Server 3.5
Wed, 23 Apr 2008 08:22:42 +1200
Hi,
Oops, accidentally posted this to the C# group so apologies for cross
posting.
VS2008 IDE Desktop app.
Anybody out there deploying this db?
I am finding a strange problem with column names.
I am using an SQLCeCommand to create a datareader.
I have a where clause that is refusing some of the column ...
|
Performance problem in sql ce
Mon, 21 Apr 2008 02:26:01 -0700
Hi,
I am very disappointed with the sql queries performance in sql ce. In my
some queries i have inner joins on 9 tables some tables have more then 150000
records. Db size is around 15 MB. If i run that query with particular where
clause (ex RoomNo. = 100) then it gives result in 1 minute otherwise i wait
...
|
Secure your MSSQL server
Mon, 21 Apr 2008 00:06:54 -0700 (PDT)
Hi Gurus,
MSSQL servers are among the most commonly used servers. But we also
know that MSSQL server security is a critical concern for most of the
database administrators. This task will become handy with the help of
Secure Auditor which is a unified digital risk management solution
capable of auditing, enfo ...
|
