Re: SQL CE Connections - Mobile Discussion Boards

Have you tried GAPI for HPC's from http://www.wincesoft.de/index.html[^] ?

This free GAPI adaption for Handheld PC's (HPC2000, Windows CE .NET 4.2, Windows CE 5.0) supports a huge list of devices:
AboCom X-Pilot MA1000, CE 3.00, 16bit
AbaCom X-Pilot MA1000, CE 3.00, 24bit
AboCom X-Pilot II FJ2500, WinCE.NET 4.2
AboCom X-Pilot II MA2300, WinCE.NET 4.1
AboCom X-Pilot II MA2300, WinCE.NET 4.2
AboCom X-Pilot II PH2500, WinCE.NET 4.2
Acer D100
Advantech MPC-100, CE 3.00, 16bit
Advantech MPC-100, CE 3.00, 24bit
AIRIS T920A
Amoi E8, CE 4.20
Audiovox Thera, CE 3.00
Becker Traffic Assist 7934
Belson BNP-90
Bluemedia BM6300, WinCE.NET 4.2
Book Digital Smartbook G138, CE 4.20
Branium Wibook, CE 4.20
Caron FDN-4000
Coxion WebBook, CE 4.10
Coxion WebBook, CE 4.20
CNS Link 40-01
Cyberbank Majesty
Cyberbank Majesty
bSquare Power Handheld, CE 4.10
Demolux dbook1, CE 4.10
Demolux dbook1, CE 4.20
DTResearch WebDT 370, CE 4.10
DTResearch WebDT 375, CE 4.10
DTResearch WebDT 375, CE 4.10
DTResearch WebDT 375, CE 4.20, PXA255
DTResearch WebDT 375, CE 4.20, PXA250
Easylite 3600 GO
Epower EzPad, CE 4.1
Fine Digital FineDrive 350 GPS
FutureCom NETA 980, CE 4.10, 16bit
Gismosoft Pad, CE 4.20
GN Technologies, Pro Navi GNB-7100D
Höft & Wessel almex.mobile
Höft & Wessel skeye.allegro (240x320 display)
Höft & Wessel skeye.mobile, CE 4.10
Höft & Wessel skeye.pad classic, HPC2000
Höft & Wessel skeye.pad classic, CE 3.00
Höft & Wessel skeye.pad classic, CE 4.10
Höft & Wessel skeye.pad SL, HPC2000
Höft & Wessel skeye.pad SL, CE 3.00
Höft & Wessel skeye.pad SL, CE 4.00
Höft & Wessel skeye.pad SL, CE 4.10
Höft & Wessel skeye.pad SL, CE 4.20
Höft & Wessel skeye.pad XSL, CE 4.20
HP Jornada 710, HPC2000
HP Jornada 720, HPC2000
HP Jornada 728, HPC2000
Hyoncorp, Hyon 2700T
Hyoncorp, Hyon 2300T
Intel PCA PXA250 Development Kit, CE 4.10
Intel PCA PXA255 Development Kit, CE 4.10
Intel PCA PXA255 Development Kit, CE 4.10
Intrinsyc CerfBoard Reference Design, CE 4.20
IPM m810, CE 4.20
IPM m810, CE 4.20
IPM m910, CE 4.20
JADE Z228 Development Board
Jamicon Navi
LILLIPUT GN715
Looket G7
Medion MD 95780
Medion MD 96800
Medion MD 96900
Medion MDPNA 150
Medion PNA 210
Medion PNA 260T
Medion PNA 320
Medion PNA 350
Medion PNA 465
Medion PNA 465T
Medion PNA 500T
Medion PNA 510T
Medion PNA MD 95900
Mio 136
Mio C210
Mio C510E
Mio C810
Mio DigiWalker C310x
Mio DigiWalker C710
MITAC, MIO DIGIWALKER, WinCE.NET 4.2
Mobilemediatech ICLIP, CE 4.00
Mobilemediatech AIV+, CE 4.00
MobiNote ep8402, CE 4.10
Moby F220, CE 4.00
Mr Handsfree Blue Pilot ONE (untested)
MUTO i7 (untested)
Navigon PNA Transonic 4000 (ADAC)
Navigon Transonic 6000T
Naviteck
NAVMAN iCN 510
NAVMAN iCN 520
NAVMAN iCN 530
NEC MobilePro 900, HPC2000
NEC MobilePro 900C, CE 4.20
NEC/NTT DoCoMo Sigmarion 3, CE 4.10
Novogo Vxx
NOVOGO t700
NOVOGO t900
Packard Bell GPS 400
Packard Bell Compasseo 600
PSC Falcon 44XX, CE 4.20
PSC Falcon 4220, CE 4.20
Psion Teklogix NetBook Pro, CE 4.20
Samsung NEXiO S151, CE 3.00, 16bit TFT
Samsung NEXiO S151, CE 3.00, 16bit CRT
Samsung NEXiO S151, CE 4.10, 16bit TFT
Samsung NEXiO S151, CE 4.10, 16bit CRT
Samsung NEXiO S155, CE 4.10
Samsung NEXiO S155, CE 4.10, 16bit TFT
Samsung NEXiO S155, CE 4.10, 16bit CRT
Samsung NEXiO S160, CE 4.10, 16bit TFT
Samsung NEXiO S160, CE 4.10, 16bit CRT
Samsung NEXiO S160, CE 4.10, 16bit TFT
Samsung NEXiO S165, CE 4.10, 16bit TFT
Samsung NEXiO S165, CE 4.10, 16bit CRT
Samsung NEXiO XP30, CE 4.10, 16bit TFT
Samsung NEXiO XP30, CE 4.10, 16bit CRT
Samsung NEXiO ZXP30, CE 4.10, 16bit TFT
Samsung NEXiO ZXP30, CE 4.10, 16bit CRT
Samsung NEXiO XP40, CE 5,00, 800x480
Samsung NEXiO XP40, CE 5,00,1024x768
Samsung S3C2410, CE 4.20
Samwell Smartpad 8402, CE 4.1
Siemens SIMpad CL4, CE 3.00
Siemens SIMpad SL 4, HPC2000,Vers. B
Siemens SIMpad SL 4, HPC2000,Vers. A
Siemens SIMpad SL 4, CE 4.00
Siemens SIMpad SL 4, CE 4.10
Siemens SIMpad SL 4, CE 4.20
Siemens SIMpad SLC, CE 4.00
Siemens SIMpad SLC, CE 4.10
Siemens SIMpad SLC, CE 4.20 (Image available at: www.mullenger.org)
Smart Solutions iBEE sp402 HPC, CE 4.10
Smart Solutions iBEE sp402p HPC, CE 4.10
Smart Solutions iBEE sp402p HPC, CE 4.20
Sony NV-U50 GPS
Southpro Midas Pad, CE 4.20
StampComputer EB2000, CE 3.00
Sumo ST370, CE 4.10
Symbol MK2000, CE 4.10
Telekom T- Sinus Pad, CE 3.00
Telekom T- Sinus Pad, CE 4.00
Telekom T- Sinus Pad, CE 4.10
Thinkware iNavi Smart
Transonic 6000T
TUBE DN-4000
TUBE ND100
Typhoon 3200 GO
Typhoon 3500 GO
Typhoon MyGuide 3000
Typhoon MyGuide 3210 GO
ViaMichelin PND X-930
Viewsonic Airpanel 100, CE 4.10
Viewsonic Viewpad, CE 3.00
Viewsonic Viewpad, CE 4.10, 24bit
Vodafone Power Handheld, CE 4.10
Yakumo EazyGo
Zupera Smartbook 7c, CE 4.20
...

Available here: http://www.wincesoft.de/html/gapi_for_hpc_s.html[^]

Does anyone know if it is possible to connect to and access the data in a pocket access (cdb) file using evc++ 4.

We are using mobile devices with pocket pc 2003 installed.

I have been trawling the internet for a bit of sample code without success and from what I read we may not be able to do this.

Thanks

stevet

If you follow any link on the baloon, the icon will disappear. I'm confused with this... The program is still running. The problem is that I use non-visible window, and the icon is the only mean to communicate to the program.
I use:
EVC++ 4.0
MS Windows Pocket PC 4.2

The icon is added to the system tray with:
m_NID.cbStruct = sizeof( SHNOTIFICATIONDATA );
m_NID.dwID = ICON_ID;
m_NID.npPriority = SHNP_INFORM;
m_NID.csDuration = 5;
m_NID.hicon = AfxGetApp()->LoadIcon( IDICON );
m_NID.grfFlags = 0;
// m_NID.grfFlags = SHNUM_ICON | SHNUM_TITLE | SHNUM_HTML;
m_NID.hwndSink = m_hWnd;
m_NID.pszTitle = TEXT( "Application" );
m_NID.pszHTML = TEXT
(
"<html><body>\
<center><a href=\"cmd:55\">Link 1</a></center> \
<center><a href=\"cmd:99\">Link 2</a></center>\
</body></html>"
);

SHNotificationAdd( &m_NID );
I tried different combinations of flags, with the same result.
The icon appears in the system tray, baloon opens, the command is sent to the window correctly. The wrong thing is that the icon disappears immediately after I have chosen a command, regardless of which link was followed.

If someone had a similar problem, or you know what is wrong with my approach, please let me know.
Many thanks in advance to everybody who will answer my question!

Andriy

Hi There

Im am trying to write my own application for my windows mobile device

I am trying to intercept an incoming call, who the person is and display it in my own application

And then answer the call normally through the phone

Using Visual Studio 2005, compact framework 2003

Thanks

Is it possible to make mobile application for simple mobile applications ( and NOT PDA's POocketPC ) using .NET framework.

No. Only for pocketPC / Smartphone.
For other devices, if supports - java micro edition (J2me).

My english is not so good. Please, correct my errors.
Best regards, Alexey.

Hi all, I'm currently developing a pocket pc application using Visual Studio 2005.

The application is designed to store data on a windows Mobile 5.0 device using SQL Server Mobile 2005 as the datastore.

My previous experience is with VB6 and Microsoft access so the theory behind the data connection is new to me and i'm pretty much learning as i go.

So far i can connect to a SQL Mobile database and display the data in a datagrid (very basic stuff i know) but i have a few questions re the differences between SQL Data connections & Access data connections that i hope someone can answer for me.

Can i connect directly to an SQL Database to edit data like in access. (if i understand correctly sql makes a temp copy of a table and then inserts the changes to the actual table when finished Unsure | :~

)?

What is the difference detween a dataadapter (and or datareader) and a vb6 Recordset??

is there a way i can use a text box and datagrid as a search tool based on the Textbox keypress event - similar to the following code in vb6

data1.databasename = dbPath
strSQL = "SELECT * FROM Table WHERE data = '" & TextBox.text & "'"
data1.recordsource = strSQL

Any help you could give me would be much appreciated and i'm sure these are probably novice questions but everybody has to start somewhere Smile | :)

.

Darren

DazJack1 wrote:
Can i connect directly to an SQL Database to edit data like in access. (if i understand correctly sql makes a temp copy of a table and then inserts the changes to the actual table when finished)?

For this type of behavior your gonna want to use a DataSet. You'll have to create the tables and relationships within the DataSet to reflect your database structure. You then call Fill() on your adapter to populate it. Then just modify the DataSet, all changes are in memory only. Then call Update() on the adapter that's mapped to it to push those changes to your database.

But this isn't really advised. On the desktop its somewhat of a performance hog, as it simulates an in memory database with all the fat and trimmings. You would be better using a custom object collection and populating that with a DataReader. Then as you make changes, use UPDATAE SQL statements to push those changes to the database. One advantage if your using the SqlCeDataReader is that you can have multiple readers open, so nesting isn't an issue when populating through multiple readers.

DazJack1 wrote:
What is the difference detween a dataadapter (and or datareader) and a vb6 Recordset??

A dataadapter adapts your DataSet to your DataBase. A datareader is just that, it reads data in a forward only pass that's fairly optimized. Its slim vs the fat of the DataSet/Adapter combo. You execute the sql, and read the values while iterating through the rows. The Recordset is a mapping to a table, view, or stored proc. Similar to the DataSet/Adapter combo, with the option of Reader like behavior, if your using custom SQL.

DazJack1 wrote:
is there a way i can use a text box and datagrid as a search tool based on the Textbox keypress event - similar to the following code in vb6

data1.databasename = dbPath
strSQL = "SELECT * FROM Table WHERE data = '" & TextBox.text & "'"
data1.recordsource = strSQL

I haven't had the need for this yet. But there are many things you can do with the databinding mechanisms in the controls and with DataSets & IList.

Off the top of my head(you'd have to search msdn to verify) I think you can put a filtered view on your DataSet to get a custom DataView that's bound to the textbox control for a parameter, and just bind the DataGrid to this view from the DataSet.

This statement is false.

I wanted some idea about mobile banking and mobile shopping
i.e i want to create a website through which this is possible so any project related to this you can post me.
you can send me code of j2me for this project.

Hi,

I hope someone can help me !

I'm trying to programatically make a connection to Bluetooth headset
from WM5 device.

Using the GU interface provided on the device, I can
a. discover the headset device, and authenicate
b. Select the headset service, however I'm not certain what is actually
done programatically when perform this selection in the GUI
c. Redirect the audio of the WM5 device to the headset.using the
following code:

HANDLE h = CreateFile(L"BAG0:",0,0,NULL,OPEN_EXISTING,0,NULL);
BOOL status = DeviceIoControl(h,IOCTL_AG_OPEN_AUDIO,NULL,0,NULL,0,NULL,NULL);
CloseHandle(h);

This all works fine !

Now If I try to achieve allow of the above without using the GUI of the device:

The following code allows me to cnnect to a headset and authenicate

if (ERROR_SUCCESS == BthCreateACLConnection (&b, &h)) {
iRes = BthAuthenticate (&b);
BthCloseConnection (h);

I was then expecting to use the the audio gateway to redirect
audio to the headset. But I can't see how this can work as at this
point I've only connected to the bluetooth device and not the headset
service, so the AG wouldn't know which device to connect to !

If I add code to connect to the headset service as shown below :

SOCKET s = socket (AF_BTH, SOCK_STREAM, BTHPROTO_RFCOMM);
SOCKADDR_BTH sab;
memset (&sab, 0, sizeof(sab));
sab.addressFamily = AF_BTH;
sab.serviceClassId = HeadsetServiceClass_UUID;
sab.btAddr = b;

if (0 != connect (s, (const sockaddr *)&sab, sizeof(sab))) {

then althought the above code connects to the headset, the connection is
terminated by the headset about ten seconds after its made.
If I use the same code to connect to a another service the connection
is not terminated.

Additionally if I try to get the AG to redirect to the Headset whilst I'm connected
to it, I can open the device BAG0:, but the IOCTL's return error 5, unable to access
device.

One thing I have noticed is that the registry doesn't contain any setting under :

HKEY_LOCAL_MACHINE\Software\Microsoft\Bluetooth\AudioGateway

But this doesn't seem to stop my using the same code to redirect the audio
if the GUI is used to establish the connection to the headset

Can you give me some pointers as I'm running out of ideas !?!

Cheers

Paul Grant

Hi all,

Does Windows Media Player Mobile supports audio plug-ins? I want to develop an equalizer and I wonder if there is a support for this.

Plz also, I wonder if I can email microsoft for programming questions, is there an email for microsoft to give such support??

Regards

And ever has it been that love knows not its own depth until the hour of separation

public NewDBBroker(string Path)
{
FileInfo fi = new FileInfo(path);
if (!fi.Exists)
CreateDataBase(Path);
else
{
DBFile = Path;
// OpenDataBase();
}
}

Hi,

I tried the above code, NotSupportedException coming..
I am using SQLLite Database.
Anybody help me,

sarala

Hello Everyone,

I'm trying to do something super simple. Just add a bunch of controls to a panel on a form. It's odd, it shows the first control, part of the second control, and doesn't show anything after that. Here is my code:

private void Inspection_Load(object sender, EventArgs e)
{
this.SuspendLayout();
Label oLabel = new Label();
oLabel.Text = "test label";

TextBox oText = new TextBox();
oText.Text = "Test textbox";
Label oLabel2 = new Label();
oLabel2.Text = "test label2";
pnlMain.Controls.Add(oLabel);
pnlMain.Controls.Add(oText);
pnlMain.Controls.Add(oLabel2);
this.ResumeLayout();

}

Any idea why something so simple isn't rendering? I did try to refresh the form, as well as recently suspending and resuming the layout.

Thanks,
Ryan

Ahh, it was just writing the controls on top of each other, guess you need to set the top of each control as you go.

Thanks,
Ryan

Hi,
I met a problem as the title. Frown | :(

Anyone who know deal with this problem?
Thanks in advance!

Best Regards,
Blackmash

Hi,

listView3.Items.Add(name + " :" + message);
listView3.Items.Add("\n");

Error:
The best overloaded method match for 'System.Windows.Forms.ListView.ListViewItemCollection.Add(System.Windows.Forms.ListViewItem)' has some invalid arguments

Is it ok if I use the above code for Windows Mobile Application , VS 2005.
I want to append the name and message in listview,but error coming.
But in the windows mobile don't have RichTextBox option and textbox.clear option,
Do you know anyother option??
Please give me the solution.

Thanks.

sarala

i have a same problem,sri harini,
where are you ? Frown | :(

I'm a novice C++ programmer and want to lear how to create simple applications and/or games for the Windows Mobile 2003 Pocket PC operating system. I can't seem to find any proper tutorial or set of sample code on the internet that actually steps one through the process of creating an application. Does anyone know where I can find such information?

Right now, Microsoft's website only has a list of all the functions in the Windows Mobile 2003 library, but doesn't show sample code with them in use!

If someone could please tell me where I could find a tutorial, step by step instructions, or a manual of some kind, I was greatly appreciate it!

Thanks in advance!!

Also, I'm currently sticking to Windows Mobile 2003 because I only haev Visual C++ .NET 2003. If anyone has any information on Windows Mobile 5.0, that would be great as well as I may move to Windows Mobile 5.0 in the near future.

There is information on the GAPI (Game API) in http://www.pocketpcdn.com/articles/gapibuffer.html ...

That might get you started..

--

Ah, you are talking about any app.. well, creating a new project in Visual Studio would put you on the right track, and from there on, it's easy to have a hello world thing going...

http://msdn2.microsoft.com/en-us/library/ms180791.aspx

Regards,
Mike

http://www.code.ae

I am trying to overwrite the power button (suspend mode button) in a Dell AXIM X51 pocket PC but I can figure out how to do that. I was able to overwrite almost all the other hardware keys but not the power button. How to overwrite the power button?

Hi Friends,

I am new to window mobile development 5.0. I would like to know the sites sites where I can learn Win32 programming for window mobile platform on .net frame work.

Can any tell me where I can find the tutorial window mobile application 5.0 from which I can develop application for window mobile operating system ?

Kindly respond to my request.

From
Phijo Smile | :)

-- modified at 6:51 Friday 4th August, 2006

Check microsoft.com/mobility or the links from this page - Windows Mobile[^]

"He that is good with a hammer tends to think everything is a nail."
- Abraham Maslow

Currently I'm able to create a combox box in ListView in Windows Form (PC application) with mouse up event in ListView, by using C#.
But is it possible to do the samething for Pocket PC Application? I'm unable to find the mouse up event in ListView. I've do lot of searching in ineternet but stilll unable to find a related article.

how can i send data from pocketpc to the server using webservice.getting input from pocket pc and the result will be displayed in server application.how can i do?
actually we display the result in pocket pc via webservice is normal.how could be i display the result in server side by receiving the input parameter from pocket pc.any ides or codings please.

I am doing merge replication using sqlserver 2000 and sqlserver mobile.In
Publishing the data,it is okay.When synchronization to the sqlservermobile,
I am getting the following error message as

A call to SQL Server Reconciler failed.Try to resynchronize.

Process could not deliver the snapshot to Subcriber.

Please help me in solving this problem.

R.Hariharan