sql ce

[Guest]

i would like to know how can i creat a sdf file in a desktop computer use vb.net
Thank you for any given answer.

 

[Amy Yuan [MS]]

Hi,

If you have installed SQL CE, you can use samples from BOL to create your
database and manipulate its data.

From BOL:
Creating a Database Through ADOXCE
Dim cat As ADOXCE.Catalog
Set cat = CreateObject("ADOXCE.Catalog.3.1")
cat.Create "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0; data
source=\NorthWind.sdf"

You can also post your message on microsoft.public.sqlserver.ce.

Thanks,
Amy

--------------------
| Thread-Topic: sql ce
| thread-index: AcQ43cWhyO+RjkwhSamvvUILCIBMTQ==
| X-WN-Post: microsoft.public.dotnet.framework.compactframework
| From: "=?Utf-8?B?bHVpcw==?=" <[email protected]>
| Subject: sql ce
| Date: Thu, 13 May 2004 04:31:02 -0700
| Lines: 2
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.compactframework
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl
microsoft.public.dotnet.framework.compactframework:53083
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
|
| i would like to know how can i creat a sdf file in a desktop computer use
vb.net.
Thank you for any given answer.
|

 

[Guest]

you are god

thanks.

 

[Alex Yakhnin [MVP]]

Amy,

Is this a "desktop" code, or for eVB on the device.

 

[Amy Yuan [MS]]

Alex,

I hope I understand your question: do you want to create a DB and run your
app on desktop using SQL CE? Or do you want to develop your app on desktop
and deploy it on device?

SQL CE is meant to run on device or emulator on desktop. It is not for
desktop. You develop your app on desktop and deploy it on device/emulator.
The code is to create a DB using SQL CE and the app can run on device or
emulator.

Amy

--------------------
| From: "Alex Yakhnin [MVP]" <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: Re: sql ce
| Date: Fri, 14 May 2004 12:34:08 -0400
| Lines: 61
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.compactframework
| NNTP-Posting-Host: 63.148.63.240
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
..phx.gbl
| Xref: cpmsftngxa10.phx.gbl
microsoft.public.dotnet.framework.compactframework:53253
| X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
|
|
| Amy,
|
| Is this a "desktop" code, or for eVB on the device.
|
| --
| Alex Yakhnin .NET CF MVP
| www.intelliprog.com | www.opennetcf.org
|
| | > Hi,
| >
| > If you have installed SQL CE, you can use samples from BOL to create
your
| > database and manipulate its data.
| >
| > From BOL:
| > Creating a Database Through ADOXCE
| > Dim cat As ADOXCE.Catalog
| > Set cat = CreateObject("ADOXCE.Catalog.3.1")
| > cat.Create "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0; data
| > source=\NorthWind.sdf"
| >
| > You can also post your message on microsoft.public.sqlserver.ce.
| >
| > Thanks,
| > Amy
| >
| > --------------------
| > | Thread-Topic: sql ce
| > | thread-index: AcQ43cWhyO+RjkwhSamvvUILCIBMTQ==
| > | X-WN-Post: microsoft.public.dotnet.framework.compactframework
| > | From: "=?Utf-8?B?bHVpcw==?=" <[email protected]>
| > | Subject: sql ce
| > | Date: Thu, 13 May 2004 04:31:02 -0700
| > | Lines: 2
| > | Message-ID: <[email protected]>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.dotnet.framework.compactframework
| > | Path: cpmsftngxa10.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
| > microsoft.public.dotnet.framework.compactframework:53083
| > | NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
| > |
| > | i would like to know how can i creat a sdf file in a desktop computer
| use
| > vb.net.
| > Thank you for any given answer.
| > |
| >
|
|
|