MS SQLCE - SqlCeParameter not recognized

Author

SqlCeParameter not recognized

David Fúnez

2005-04-20, 11:23 am

Ok;

I see in the forums that this line of code should work, but if i use it, the
SqlDbType to select the type of record doesn't work.

cmd.Parameters.Add(new SqlCeParameter("param1", SqlDbType.Int))

i do this: cmd.Parameters.Add(new SqlCeParameter("param1", XXXX <<< Here i
can't use SqlDbtype.....

im using all this referencies to check out if with one of this it works, but
is the same problem:

Imports System

Imports System.IO

Imports System.Text

Imports System.Data

Imports System.Data.SqlServerCe

Imports System.Collections

Imports System.Windows.Forms

Imports System.Data.Common

Any Help

--
David Fúnez
Tegucigalpa, Honduras

Faust

2005-04-20, 1:23 pm

SqlDbType is defined in System.Data.SqlClient

/_David Fúnez_ a exposé/ :
> Ok;
>
> I see in the forums that this line of code should work, but if i use it, the
> SqlDbType to select the type of record doesn't work.
>
> cmd.Parameters.Add(new SqlCeParameter("param1", SqlDbType.Int))
>
> i do this: cmd.Parameters.Add(new SqlCeParameter("param1", XXXX <<< Here i
> can't use SqlDbtype.....
>
> im using all this referencies to check out if with one of this it works, but
> is the same problem:
>
> Imports System
>
> Imports System.IO
>
> Imports System.Text
>
> Imports System.Data
>
> Imports System.Data.SqlServerCe
>
> Imports System.Collections
>
> Imports System.Windows.Forms
>
> Imports System.Data.Common
>
> Any Help

--
*/Teträm/*
http://www.tetram.info

"Tape d'abord, tape ensuite, et tape pour finir" - Proverbe Troll

David Fúnez

2005-04-20, 8:23 pm

ok;

But i just can see System.Data or System.Data.SqlServerCe, not SqlClient.

Thanks;

--
David Fúnez
Tegucigalpa, Honduras

"Faust" <miss.me@no.where.invalid> wrote in message
news:mn.a4ab7d54fa3d0735.16328@chez.moi.invalid...
> SqlDbType is defined in System.Data.SqlClient
>
> /_David Fúnez_ a exposé/ :
>
> --
> */Teträm/*
> http://www.tetram.info
>
> "Tape d'abord, tape ensuite, et tape pour finir" - Proverbe Troll
>

Darren Shaffer

2005-04-21, 3:23 am

SqlClient is a separate assembly that allows you to directly access SQL
Server
from Compact Framework applications. if this is your intention, in Visual
Studio,
just add a reference to your CF project to System.Data.SqlClient. If you
plan to
work with SQL CE, you want to use System.Data.SqlServerCe. SqlDbType.Int32
is what you want.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"David Fúnez" <dfunez@hotmail.com> wrote in message
news:OCXHVVeRFHA.1500@TK2MSFTNGP09.phx.gbl...
> ok;
>
> But i just can see System.Data or System.Data.SqlServerCe, not SqlClient.
>
> Thanks;
>
> --
> David Fúnez
> Tegucigalpa, Honduras
>
>
> "Faust" <miss.me@no.where.invalid> wrote in message
> news:mn.a4ab7d54fa3d0735.16328@chez.moi.invalid...
>
>

Sponsored Links