Create DB Compact3.5

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kjqua - 01 Mar 2008 09:25 GMT

Hello,

I'm looking for an example or tutorial that explain how create a
DataBase at run time though C#.
And then how to populate the Database with Tables and columns.

Thanks
Marco

Reply to this Message

ErikEJ - 01 Mar 2008 12:35 GMT

This page shows several ways of creating databases:
http://msdn2.microsoft.com/en-us/library/ms172404(SQL.100).aspx

To create tables and columns, you can use SQL Statements in SQL Server
Management Studio (CREATE TABLE), or use the graphical tools in Visual
Studio or SQL Server Management Studio.

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

> Hello,
>
[quoted text clipped - 4 lines]
> Thanks
> Marco

Reply to this Message

kjqua - 02 Mar 2008 09:45 GMT

ErikEJ ha scritto:

> This page shows several ways of creating databases:
> http://msdn2.microsoft.com/en-us/library/ms172404(SQL.100).aspx
>
> To create tables and columns, you can use SQL Statements in SQL Server
> Management Studio (CREATE TABLE), or use the graphical tools in Visual
> Studio or SQL Server Management Studio.

ErikEj,

Thanks.

marco

Reply to this Message

Joaquim jpais - 02 Mar 2008 17:41 GMT

Hello,

See Data Port Console

Manage all your SQL Compact Edition databases from one central location with
the new Data Port Console

http://www.primeworks-mobile.com/Products/DataPortConsole.html

regards.
JP

Hello kjqua,

> ErikEJ ha scritto:
>
[quoted text clipped - 10 lines]
>
> marco

Reply to this Message

William Vaughn - 03 Mar 2008 18:10 GMT

My Ebook discusses about 5 ways to create databases. Since the examples are
in VB.NET I'm sure you won't have any trouble translating them. See
www.hitchhikerguides.net FMI.

Signature

__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

> Hello,
>
[quoted text clipped - 4 lines]
> Thanks
> Marco

Reply to this Message