DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Thread: sql server CE and visual studio

  1. #1
    Join Date
    Aug 2007

    sql server CE and visual studio


    Actually i am developing a device application in i am using windows mobile 6, visual studio 2005 and SQL server compact edition. my application is working fine but the problem i am facing is that i can't insert any record in the database programmatically when i use device application but if i use windows application then i does insert the record in database which i have created in SQL server CE using the data connection wizard. just like in Justin Whitney's article
    Your First Windows Mobile Database App: SQL Server 2005 Compact Edition (CE) on Windows Mobile 6
    i used the connection wizard to create database and inserted record manually.
    But when i insert record programmatically using sqlCeConnection it throws an exception of directory not found or invalid path eventhough the directory is same in which i have created the database.
    In this form of Device application, i am retrieving the record from the same table as well by using the same technique which Justin mentioned in his above article.(i.e. dataset and binding source, using wizard)
    So, please can anyone help me out ( by some code snippet or tips) in inserting the data in the database table or is there any other way to insert data as he retrieved data in your article using the dataset, binding source and table adapter as it is very important for my dessertation and very soon i have to submit my dessertation.

    I willbe really thankful

    Last edited by shabie; 08-08-2007 at 03:58 PM. Reason: to make it more precise

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center