C# device application,sql serverCE, background services

Posted on 2007-07-30
Last Modified: 2013-12-17
Hi every one,
I am developing an application in visual for smart devices. I am using windows mobile 6 professional emulator for deployment of my application. For device applications in visual studio 2005, if you are dealing with any database then you have to use the sql server compact edition. I have created my database using sql server compact edition. The problems which i am facing are

1) One of my table will contain the bmp images, but if any one knows the sql server compact eidtion there is no option to insert any image in database at design view even though you can enter the other data. , i have tried it several times by programming but it always throws an exception of directory not found. I put the image in my emulator memory as well but it didn't work.if any one can please help me in inserting bmp image in the data base.

2) I want my application (written in c#) to keep running in background and work as a reminder which comes on screen of device at any specific time and keep synchronizing with the sql server compact edition database. Just like when we set an alarm or reminder in the mobile, i want my application to work as a reminder which will be displayed when the system time and the time in databse is matched and the reminder should be reset again for the next entry in database.

If any one knows the solution of these problems, please post it as soon as possible, I will be really thankful

Question by:shabie
    1 Comment
    LVL 48

    Accepted Solution

    1) It looks like you cant insert an image but you can save it to Memory and create a table Images and Have an Idenity ID and Image Path which will hold the path to th eimage.

    2) You can use a Timer System.Threading to check for changes and then the notification control to notify you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Our Group Policy work started with Small Business Server in 2000. Microsoft gave us an excellent OU and GPO model in subsequent SBS editions that utilized WMI filters, OU linking, and VBS scripts. These are some of experiences plus our spending a lo…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
    Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now