C# Pocket PC Application With Sql Server Mobile

Hi,

I am absolutely new to Smart Device Application programming. I want to make my application work with Sql Server Mobile. I have been through a lot of links and very confused. I need some guidance from the expert on how to start with it.

Development environment in use:
1. Windows 2000 Server
2. C# .NET 2005
3. Sql Server 2000

I have already tried a basic 2 forms application and tested it on a Smart Phone and i-mate JASJAR, and found the application working properly.

My questions are as follows:

1. How to use my application so that I can connect to Sql Server Mobile
2. Do I have to install Sql Server Mobile on my development computer
3. If so from where will I download it Doesn't .NET Studio comes with its own Mobile Database
4. How to add a new table in Sql Server Mobile Is there any interface like Enterprise Manager to access it

Looking ahead for some helpful suggestions from you all. Thanking you in anticipation.

Suman.



Answer this question

C# Pocket PC Application With Sql Server Mobile

  • boran_blok_edan

    Please do not cross post. Merging threads...



  • Crane101

    See the responses from Ilya and this should get you started. If you've other issues than please post them.

    Manav



  • kadabba

    1. You connect to SQL Server mobile via SqlCeConnection object in System.Data.SqlServerCe namespace. Please see MSDN for details and samples.

    2. Same way as any other application - copy SQL Sever Mobile CAB on to your device and click on it. VS 2005 would do that for you on a first deployment.

    3. Yes, VS 2005 SE or above comes with SQL Server Mobile included.

    4. You can:

    - Create table programmatically by executing query.

    - Use "enterprise manager" like application called "Query analyzer" on device.

    - Create database in VS 2005 designers.



  • olloemre

    Hi,

    I am absolutely new to Smart Device Application programming. I want to make my application work with Sql Server Mobile. I have been through a lot of links and very confused. I need some guidance from the expert on how to start with it.

    Development environment in use:
    1. Windows 2000 Server
    2. C# .NET 2005
    3. Sql Server 2000

    I have already tried a basic 2 forms application and tested it on a Smart Phone and i-mate JASJAR, and found the application working properly.

    My questions are as follows:
    1. How to use my application so that I can connect to Sql Server Mobile
    2. Do I have to install Sql Server Mobile on my development computer
    3. If so from where will I download it Doesn't .NET Studio comes with its own Mobile Database
    4. How to add a new table in Sql Server Mobile Is there any interface like Enterprise Manager to access it

    Looking ahead for some helpful suggestions from you all. Thanking you in anticipation.

    Suman.


  • Fazul

    Hi mgaur and Ilya,

    Could you also help me on:
    http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=839026&SiteID=1

    I am badly stuck, and not getting any response from anyone.

    Please please help me.

    Thanx,
    Suman


  • Cavetroll

    Ok I am sorry, actually I am new to this forum and needed help badly.


  • C# Pocket PC Application With Sql Server Mobile