SqlDbType collection is not available

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Studio.NET 2003 Pro. to develop a smart device application.I can't
use any parameter declarations because there is no System.Data.SqlDbType
collection.
I have this collection available under the full framework 1.1.(VB,C# Windows
or web applications) but not in the compact framework.

Any ideas?

Thank You
 
Could you use a temp table and temporarily store the value of your would be
parameter there and build a relationship to query against that value?
 
No, you can. Use DbType instead of SqlDbType:

VB:
pDate = New SqlServerCe.SqlCeParameter
pDate.DbType = DbType.DateTime
pDate.Value = DateSerial(2004,04,11)
....

Best regards,
Sergey Bogdanov
 
Add a reference to System.Data.Common.dll - this is where the SqlDbType
enumeration is in the Compact Framework (on the desktop it's included in
System.Data.dll).

Peter
 
Thank You Peter.
It did work to generate the code on the development desktop,but
on the CE device I get the error "Could not find resource assembly"

Manole
 
Actually, the error is not at all about "resource assembly". It's an
exception caused by something in your code.
Please see this:
http://blogs.msdn.com/netcfteam/archive/2004/08/06/210232.aspx

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
Thread-Topic: SqlDbType collection is not available
thread-index: AcT3Qxgu3nL+BDY9RdynfJU4G1fD/A==
X-WBNR-Posting-Host: 38.148.168.5
From: =?Utf-8?B?bWFub2xl?= <[email protected]>
References: <[email protected]>
Click to expand...
 
Back
Top