ok I start programming mobile application with VB.NET (VS 2005)
I am interested work with Sqlce
Also I look for add reference in my project

I search   "System.Data.SqlServerCe" but not found.
Where is? Sqlce is not installed by default?

Thanks

Hi,

        VB 2005 should come with sql server 2005 mobile the version for sql
server 2005.

Ken
---------------------
Show quoteHide quote

Titeuf,

What version of VB.Net

Cor

Titeuf,

What version of VB.Net(2005)

Cor

I use last MSDN Visual Studio 2005  (I have no exact version here)
But, I suppose I would reinstal (?)

Show quoteHide quote

Ok. My probleme is solved.
In fact.
First not use Microsoft Desktop Search for search "System.Data.SqlServerCe"
Just use the old search with Explorer ;-)
After, I found - just Projet/Add Reference with Browse  - etc. for others
*.dll

Last, my big problem:
I have problem with System.Data.Sqlce.common.dbConnection
Il juste create a small program and compare  *.vbproj file:


*.vbproj  (GOOD project)
----------------------------------
<ItemGroup>
    <Reference Include="System" />
    <Reference Include="System.Data" />
    <Reference Include="System.Data.SqlClient, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL" />
    <Reference Include="System.Data.SqlServerCe, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL" />
    <Reference Include="System.Drawing" />
    <Reference Include="System.Windows.Forms" />
  </ItemGroup>

*.vbproj (BAD)
---------------------
  <ItemGroup>
    <Reference Include="CustomMarshalers" />
    <Reference Include="System" />
    <Reference Include="System.Data.Common, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>..\..\..\..\Program Files\Microsoft Visual Studio
8\SmartDevices\SDK\SQL Server\Mobile\v2.0\System.Data.Common.dll</HintPath>
    </Reference>
    <Reference Include="System.Data.SqlClient, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>..\..\..\..\Program Files\Microsoft SQL Server 2005 Mobile
Edition\Device\Client\v2.0\System.Data.SqlClient.dll</HintPath>
    </Reference>
    <Reference Include="System.Data.SqlServerCe, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>..\..\..\..\Program Files\Microsoft SQL Server 2005 Mobile
Edition\Device\Mobile\v3.0\System.Data.SqlServerCe.dll</HintPath>
    </Reference>
    <Reference Include="System.Drawing" />
    <Reference Include="System.Windows.Forms" />
  </ItemGroup>

The difference is probably because I start with a project created with VS
2003.
I gess replace the BAD ItemGroup with GOOD ItemGroup
Bingo!
I create database, table etc. with Sqlce

master volume control in winmm using namespaces
Problem with Structures using FieldOffset -- BUG?
How to get worksheet names from an excel file?
Is Office required on End user's PC ?
VB.Net code to upsize Access DB to SQL Express?
Changing default printer.....
VB.Net vs Access vs Deployment
Array Objects pointers, value types reference types??
Streams, Files, Readers and Writers
GraphicsPath intersections