GUI way for DB and tables in mobile devices

S.Vinothkumar · #1 (**permalink**) 10-30-2007, 11:35 PM

Hi all,

I need to create db and create table there in mobile device.

I have already created the database itself on the device, but I need a way to add tables and columns to those tables and establish relationships. Is there a GUI way to do this?

amansundar · #2 (**permalink**) 11-01-2007, 02:50 AM

Are you using vs2005?

S.Vinothkumar · #3 (**permalink**) 11-04-2007, 11:13 PM

Yes...

I'm using VS.2005. I've added the database as a datasource and I can create the tables and stuff that way, but it appears that it's only a dataset and not the actual database file.

Is there a quick way I could just update my dataset to the database?

amansundar · #4 (**permalink**) 11-16-2007, 03:03 AM

Hi friend ,

I prefer to create the DB objects through code - it's rather simple...

But to do it from VS 2005

VIEW menu - Server Explorer. You will see Data Connections - ADD connections. I left it selected to My Computer - browsed to a folder where the SQL CE db was - put in the password - tested the connection - all that worked.

S.Vinothkumar · #5 (**permalink**) 11-16-2007, 10:19 PM

Thanks!

I've created my tables and columns using code,

How do I assign a column as the primary key?

Is there a way to get it to auto increment as I add new records?

amansundar · #6 (**permalink**) 11-19-2007, 01:18 AM

Hi buddy...

Code:

Create Table XYZ (Col1 int identity, Col2 nvarchar(1), Primary Key (Col1))

I believe that's the SQL CE syntax for auto-increment (identity) and how to create a primary key.

S.Vinothkumar · #7 (**permalink**) 11-26-2007, 06:45 AM

When I try to create it on my computer it gives me an OK on test connection, but when I try to hit next, it fails and says it can't access the file.

It works fine when I create it on my device though, but I still end up with a dataset and not the actual database file in datasources explorer.

S.Vinothkumar · #8 (**permalink**) 11-28-2007, 09:49 PM

...

I'll give your code a try, thanks again for the help. More to come I'm sure.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What is the cache sizes for mobile devices?	S.Vinothkumar	Windows Mobile	6	11-20-2007 01:45 AM
How Can we search Bluetooth Devices using C# for windows mobile?	mobilegeek	Windows Mobile	2	08-17-2007 08:07 AM
VISTA - Able to use Concurrent Devices	prasannavigneshr	Operating Systems	8	08-02-2007 04:07 AM
Can I nest tables within tables?	oxygen	HTML, CSS and Javascript Coding Techniques	2	07-27-2007 03:33 AM
Any idea about Connecting Windows Mobile to Wireless HID devices?	itbarota	Windows Mobile	0	07-23-2007 07:12 AM