Click here to Skip to main content
15,896,063 members
Articles / Mobile Apps / Windows Mobile

Accessing MS SQL Server CE v1.0/v2.0 without ADO

Rate me:
Please Sign up or sign in to vote.
4.53/5 (17 votes)
2 Mar 2003CPOL3 min read 374.2K   840   43  
Add, edit, and delete records/table/database in MS SQL Server CE v1.0/v2.0.
//Microsoft eMbedded Visual C++ generated resource script.
//
#include "resource.h"

#define APSTUDIO_READONLY_SYMBOLS
/////////////////////////////////////////////////////////////////////////////
//
// Generated from the TEXTINCLUDE 2 resource.
//
#include "afxres.h"

/////////////////////////////////////////////////////////////////////////////
#undef APSTUDIO_READONLY_SYMBOLS

/////////////////////////////////////////////////////////////////////////////
// English (U.S.) resources

#if !defined(AFX_RESOURCE_DLL) || defined(AFX_TARG_ENU)
#ifdef _WIN32
LANGUAGE LANG_ENGLISH, SUBLANG_ENGLISH_US
#pragma code_page(1252)
#endif //_WIN32

/////////////////////////////////////////////////////////////////////////////
//
// Icon
//

// Icon with lowest ID value placed first to ensure application icon
// remains consistent on all systems.
IDI_ICON1               ICON    DISCARDABLE     "res\\icon1.ico"

/////////////////////////////////////////////////////////////////////////////
//
// Bitmap
//

IDR_TOOLBAR             BITMAP  DISCARDABLE     "res\\toolbar1.bmp"
IDB_BITMAP1             BITMAP  DISCARDABLE     "res\\bitmap1.bmp"

#ifdef APSTUDIO_INVOKED
/////////////////////////////////////////////////////////////////////////////
//
// TEXTINCLUDE
//

1 TEXTINCLUDE DISCARDABLE 
BEGIN
    "resource.h\0"
END

2 TEXTINCLUDE DISCARDABLE 
BEGIN
    "#include ""afxres.h""\r\n"
    "\0"
END

3 TEXTINCLUDE DISCARDABLE 
BEGIN
    "\r\n"
    "\0"
END

#endif    // APSTUDIO_INVOKED


/////////////////////////////////////////////////////////////////////////////
//
// Toolbar
//

IDR_TOOLBAR TOOLBAR DISCARDABLE  16, 16
BEGIN
    BUTTON      IDB_BUTTON1
    BUTTON      IDB_BUTTON2
    BUTTON      IDB_BUTTON3
    BUTTON      IDB_BUTTON4
    BUTTON      IDB_BUTTON5
    BUTTON      IDB_BUTTON6
    BUTTON      IDB_BUTTON7
END


/////////////////////////////////////////////////////////////////////////////
//
// Dialog
//

IDD_DIALOG1 DIALOG DISCARDABLE  0, 0, 132, 85
STYLE DS_MODALFRAME | DS_CENTER | WS_POPUP | WS_VISIBLE | WS_CAPTION | 
    WS_SYSMENU
CAPTION "Connect to SQL Server CE"
FONT 8, "System"
BEGIN
    ICON            IDI_ICON1,IDC_STATIC,7,7,20,20
    LTEXT           "SQL Server CE Database",IDC_STATIC,35,12,88,8
    LTEXT           "Path:",IDC_STATIC,5,33,19,8
    EDITTEXT        IDC_EDIT1,26,32,83,12,ES_AUTOHSCROLL | NOT WS_BORDER,
                    WS_EX_STATICEDGE
    PUSHBUTTON      "...",IDC_BUTTON1,111,32,13,12
    PUSHBUTTON      "Connect",IDC_BUTTON2,5,57,50,14
    PUSHBUTTON      "Create",IDC_BUTTON3,75,57,50,14
END

IDD_DIALOG2 DIALOG DISCARDABLE  0, 0, 132, 85
STYLE DS_MODALFRAME | DS_CENTER | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "Database option..."
FONT 8, "System"
BEGIN
    ICON            IDI_ICON1,IDC_STATIC,7,7,20,20
    LTEXT           "SQL Server CE Database",IDC_STATIC,35,12,88,8
    LTEXT           "Path:",IDC_STATIC,5,33,19,8
    EDITTEXT        IDC_EDIT1,26,32,83,12,ES_AUTOHSCROLL | NOT WS_BORDER,
                    WS_EX_STATICEDGE
    PUSHBUTTON      "...",IDC_BUTTON1,111,32,13,12
    PUSHBUTTON      "Compact",IDC_BUTTON2,5,57,50,14
    PUSHBUTTON      "Delete",IDC_BUTTON3,75,57,50,14
END

IDD_DIALOG3 DIALOG DISCARDABLE  0, 0, 132, 85
STYLE DS_MODALFRAME | DS_CENTER | WS_POPUP | WS_CAPTION | WS_SYSMENU
CAPTION "About..."
FONT 8, "System"
BEGIN
    ICON            IDI_ICON1,IDC_STATIC,7,7,21,20
    CTEXT           "SQL Server CE Database\r\nSample Program\r\n\r\nDeveloped by: C. Chris",
                    IDC_STATIC,35,7,82,38
END


/////////////////////////////////////////////////////////////////////////////
//
// DESIGNINFO
//

#ifdef APSTUDIO_INVOKED
GUIDELINES DESIGNINFO DISCARDABLE 
BEGIN
    IDD_DIALOG1, DIALOG
    BEGIN
        RIGHTMARGIN, 131
        TOPMARGIN, 1
        BOTTOMMARGIN, 84
    END

    IDD_DIALOG3, DIALOG
    BEGIN
        RIGHTMARGIN, 131
        BOTTOMMARGIN, 84
    END
END
#endif    // APSTUDIO_INVOKED


#ifndef _MAC
/////////////////////////////////////////////////////////////////////////////
//
// Version
//

VS_VERSION_INFO VERSIONINFO
 FILEVERSION 1,0,0,0
 PRODUCTVERSION 1,0,0,0
 FILEFLAGSMASK 0x3fL
#ifdef _DEBUG
 FILEFLAGS 0x29L
#else
 FILEFLAGS 0x28L
#endif
 FILEOS 0x40004L
 FILETYPE 0x1L
 FILESUBTYPE 0x0L
BEGIN
    BLOCK "StringFileInfo"
    BEGIN
        BLOCK "040904b0"
        BEGIN
            VALUE "Comments", "\0"
            VALUE "CompanyName", "BoKia (M) SDN BHD\0"
            VALUE "FileDescription", "MySqlCe\0"
            VALUE "FileVersion", "1, 0, 0, 0\0"
            VALUE "InternalName", "MySqlCe\0"
            VALUE "LegalCopyright", "Copyright � 2002\0"
            VALUE "LegalTrademarks", "\0"
            VALUE "OriginalFilename", "MySqlCe.exe\0"
            VALUE "PrivateBuild", "0828\0"
            VALUE "ProductName", "BoKia (M) SDN BHD\0"
            VALUE "ProductVersion", "1, 0, 0, 0\0"
            VALUE "SpecialBuild", "CE.NET\0"
        END
    END
    BLOCK "VarFileInfo"
    BEGIN
        VALUE "Translation", 0x409, 1200
    END
END

#endif    // !_MAC

#endif    // English (U.S.) resources
/////////////////////////////////////////////////////////////////////////////



#ifndef APSTUDIO_INVOKED
/////////////////////////////////////////////////////////////////////////////
//
// Generated from the TEXTINCLUDE 3 resource.
//


/////////////////////////////////////////////////////////////////////////////
#endif    // not APSTUDIO_INVOKED

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer
Australia Australia
Passion to be a software architect and solution researcher in enterprise solutions by simplify and unify the existing complex manual paper works into an automated environment friendly, comprehensive and dynamic workflow process system.

Comments and Discussions