Re: SqlCeConnection issues - Mobile Discussion Boards

ctlqt1211-Nov-06 19:29

11-Nov-06 19:29

Mobile Web Application is very new for me. And i tried to make a simple project about it. So i used VS 2003 and created a Mobile Web Application. I used NWB 4.0 to display the page. But the page couldn't be displayed ( the page could be displayed in IE ) . I only saw the earth icon was always moving and nothing more.

So why's that happened? And how could i solve this problem?

"SendKeys" for a mobile device ???

reinhard_jd10-Nov-06 10:51

reinhard_jd

10-Nov-06 10:51

Hi folks,

I have to write a background application for a mobile terminal (equipped with
integrated scaner engine, keyboard, serial port and so on...) with a CE4.2 OS.
The app shall read data from the serial port, do a little magic with this data
(changing some letters against others, deleting carrige returns) and insert the
result into a textbox of the current foreground application.

Serial communication isn't the problem, but inserting the data into the textbox
is a real head-scratcher to me. Confused | :confused:

I wrote a similar application for a normal PC. Then I used the SendKeys class
to to the job, but unfortunately this class isn't available in the Compact
Framework. Frown | :(

I thought about using P/Invoke, but I don't have a clue which function of which
dll I should use... Sniff | :^)

Does anyone have an idea how to solve this problem?

Thanks in advance!

Reinhard

Accessing Oracle from device

Richard Jones10-Nov-06 8:01

Richard Jones

10-Nov-06 8:01

I started reading about synchronizing SQLServer CE. It involves IIS, shadow folders and SQL Server 2000.
What if all our data is on Oracle? Without going too deep, is there a way for IIS to use that instead?

I have no IIS experience. If there is a way to avoid that I'd prefer it.

He was a snowflake, like other "unique" snowflakes, falling down, getting stepped on, and pushed aside to disappear.

Missing System.Data.ODBC

nemopeti9-Nov-06 21:41

nemopeti

9-Nov-06 21:41

Hi!

I try to develop my first PDA application, and it works fine, until I not use database functionality.
I try to manage an access database via ODBC, but System.Data.ODBC is missing in my mobile solution, what do I need to make this work?

Need solution for Win Mobile 5, and 2003 too.

Or is there better format, or way for databases on PDA?

I have Visual Studio 2005 Professional, and SQLExpress 2005.

If somebody have links for PDA sourcecodes please send to me.

Thanks for help!

SocketRecieveTimeout in .NetCompactFramework

aruna_koride9-Nov-06 20:21

aruna_koride

9-Nov-06 20:21

Please read this from MSDN.

In .NET Compact Framework applications, the following options are supported but not working and are currently reserved for future use: AcceptConnection, ReceiveLowWater, ReceiveTimeout, SendLowWater, SendTimeout, and Type.

I am trying to set ReceiveTimeout using SetSocketOption, but throwing exception.

Pls advise the alternate way to set socket receive timeout.

Thanks
Aruna

SqlCeConnection issues

RB@Emphasys9-Nov-06 6:26

RB@Emphasys

9-Nov-06 6:26

Hello All,

I'm using cf 2.0 on the emulated ppc 2003 device that is bundled with vs2005. For some reason, when I attempt to connect to my database it throws a sqlexception error with no error message. My code is as follows:

SqlCeEngine engine = new SqlCeEngine("Data Source='\\Program Files\\UCPS\\UPCS.sdf';");
if (!(File.Exists("\\Program Files\\UCPS\\UPCS.sdf")))
engine.CreateDatabase();

SqlCeConnection connection = new SqlCeConnection(engine.LocalConnectionString);
connection.Open();

I can connect to the database on the device just fine. The database has no password. In this code sample, it does indeed find the UPCS.sdf file in the second line and does not try and create a new one. But when I try to open the connection, it errors out with no message. The only data I have is

HResult = -2146233087
StackTrace = StackTrace "at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()\r\nat System.Data.SqlServerCe.SqlCeConnection.Open()\r\nat System.Data.SqlServerCe.SqlCeConnection.Open()\r\nat UPCS.Data.StatusTable.RetrieveStatusRecords()\r\nat UCPS.Main.Main_Load()\r\nat System.Windows.Forms.Form.OnLoad()\r\nat System.Windows.Forms.Form._SetVisibleNotify()\r\nat System.Windows.Forms.Control.set_Visible()\r\nat System.Windows.Forms.Application.Run()\r\nat UCPS.Program.Main()\r\n" string

I would really appreciate any suggestions,

Thanks,
Ryan

Re: SqlCeConnection issues

RB@Emphasys9-Nov-06 8:05

RB@Emphasys

9-Nov-06 8:05

I can connect to an empty database. I created my db through visual studio 2005. Are there any issues creating a db through the ide that would cause it to not work properly?

Thanks,
Ryan

Re: SqlCeConnection issues

Richard Jones10-Nov-06 8:10

Richard Jones

10-Nov-06 8:10

         If File.Exists("\My Documents\pam.sdf") Then<br />
            File.Delete("\My Documents\pam.sdf")<br />
         End If<br />
<br />
         Dim sqlEngine As SqlCeEngine<br />
         sqlEngine = New SqlCeEngine<br />
         sqlEngine.LocalConnectionString = "Data Source=\My Documents\pam.sdf;password=;Encrypt Database=False"<br />
         sqlEngine.CreateDatabase()<br />
<br />
         Dim myConnection As New SqlCeConnection("Data Source=\My Documents\pam.sdf;password=")<br />
         myConnection.Open()

He was a snowflake, like other "unique" snowflakes, falling down, getting stepped on, and pushed aside to disappear.

Transparent Control

Manish19727-Nov-06 2:10

Manish1972

7-Nov-06 2:10

Hello everybody

I am working on PocketPc WM5.0. Uisng Vs2005 C# for the developmen platform.
I want to make ,, my own control which should be transparent .
Normally control's background color is ,what we set to Back color property . But i want this to be transparent so that i can see through it.

How can i do that ...?

Please suggest

Regards
Manish

Re: Transparent Control

arcticbrew21-Nov-06 17:36

arcticbrew

21-Nov-06 17:36

using gdi you can draw with transparency

l_Icon is a bitmap

ImageAttributes imageAttr = new ImageAttributes();

// set the transparency of the image to be shown using the selected pixel
imageAttr.SetColorKey(l_Icon.GetPixel(0, 0), l_Icon.GetPixel(0, 0));

// draw the custom graphic
g.DrawImage(l_Icon, dstRect, 0, 0, l_Icon.Width, l_Icon.Height, GraphicsUnit.Pixel, imageAttr);

Virtual IP - Vertical Handoff

kedde17-Nov-06 1:56

kedde1

7-Nov-06 1:56

Hi! I really hope somebody can help me.

I am doing a school project on vertical handoff. A Linux workstation and a Pocket Pc (windows mobile 2003) are communicating through WiFi and Bluetooth. The system should always choose the connection technology that is best under the current conditions, if for instance the bluetooth connenction is currently being used, and the connection is lost, the system should transparently switch to WiFi, instead and vice versa.
My goal is that the user or an application uses only one ip-connection, hence achieving trancparent handover between the two technologies.

Now let's say the Linux PC has the following adresses:
BT: 10.0.0.1
WiFi: 10.1.1.1
and the PPC has:
BT: 10.0.0.2
WiFi: 10.1.1.2

Then I what to create a virutal IP (VIP):
Linux PC: 10.2.2.1
PPC: 10.2.2.2

The VIP should then "forward" the communication to the active connection.

I can successfully create a virtual IP on the Linux PC, and then assign this to the currently active connection.

Can I anyhow do the same thing on the Pocket PC?
I would prefer to do this in C# but C++ is an option.

I hope you understand my problem, my english might be a bit rusty, but i will try to elaborate if needed. Thx in advance.

Questions regarding Compact Framework.

Aasifkhan6-Nov-06 18:20

Aasifkhan

6-Nov-06 18:20

Hi,
While working with compact framework i stuck at following queries,If anyone can help me to solve this ,plz answer me.

1. Can we create a copy of database (.sdf files) of PPC to our desktop machine and accesse those files without connecting to PPC ?

2.Is there any unique number associated with the PPC device so that we can Identify it when ever it connected to our desktop?
If yes then how to get that number or is there any other way we can achieve this requirement.

3.i m using dataset for filling the comboboxes on Page Load event but it is throwing an exception .If i fill only one combo then the code works fine but if i m filling 2 combos at the same time ,it gives problem.What will be the problem ?

Available Memory and Free Disk Space in CF 1.0

Marco [Stinger]6-Nov-06 6:04

Marco [Stinger]

6-Nov-06 6:04

Ciao,
is there any managed class or unmanaged API I can call to know the available memory and disk space on a WinCE device (CF 1.0 )

Thanks in Advance

Ciao
Marco

Re: Available Memory and Free Disk Space in CF 1.0

zoid ! 9-Nov-06 6:16

zoid !

9-Nov-06 6:16

Howdy,

I'm not sure about managed (.net) functions but the following unmanaged (C/C++) functions may be of interest to you:

Memory:

GlobalMemoryStatus

Disk:

GetDiskFreeSpaceEx

These maybe useful as well:

GetStoreInfo
CeGetVolumeInfo (CE 5.0 only)

Re: Available Memory and Free Disk Space in CF 1.0

Marco [Stinger]9-Nov-06 6:27

Marco [Stinger]

9-Nov-06 6:27

GRAZIE !!

Problems with IssueVendorTransfer

slowdiver6-Nov-06 4:00

slowdiver

6-Nov-06 4:00

Hello!

I have problems with the IssueVendorTransfer function. All parameters are
correct, the mistakes messages are:

DBGCHK failed in cpipe.cpp line 891
DBGCHK failed in transfer.hpp

What I make wrong!

I use Platform Builder 5.0 with CEPC

EHCI Host Controller

Here my call of the function:

ControlHeader.bmRequestType = USB_REQUEST_DEVICE_TO_HOST | USB_REQUEST_CLASS
| USB_REQUEST_FOR_INTERFACE;
ControlHeader.bRequest = 254;
ControlHeader.wValue = 0;
ControlHeader.wIndex = 0;
ControlHeader.wLength = 0;

dwErr = IssueVendorTransfer( pUMC->UsbFuncs,
pUMC->hUsbDevice,
DefaultTransferComplete,
pUMC->hEP0Event,
(USB_IN_TRANSFER|USB_NO_WAIT|USB_SHORT_TRANSFER_OK),
&ControlHeader,
pBuffer, 0,
&dwBytesTransferred,
pUMC->UsbTimeouts.DeviceIdTimeout,
&dwUsbErr );

Thank you

How to access the .sdf file's created in Pocket PC from compact framework emulator

Aasifkhan6-Nov-06 1:50

Aasifkhan

6-Nov-06 1:50

Hi,
i m working on application related with PDA ,I want to know "How to access the .sdf file's created in Pocket PC from compact framework emulator Without using PDA ".Is there any way so that we can create the copy of database(.sdf files) present in PDA on our desktop?

Regards,
Asifkhan.

Re: How to access the .sdf file's created in Pocket PC from compact framework emulator

AlexeiXX37-Nov-06 18:20

AlexeiXX3

7-Nov-06 18:20

Cant you just copy the file to your desktop??
But if you really want to work with the DB in your PPC, OK.
Im using VS.NET 2005.
1-Open VS
2-In your server explorer click on add new connection
3-For the data provider choose MSSQL Server Mobile Edition
4-On the datasource choose: "Active sync connected device"
5-Browse for the database or create a new one, if its password protected, write it in the password field
6-Test the connection
And you are done

But again...If I were you, i would create the DB on my desktop (same steps as above but instead of choosing "Active sync connected device" youd choose "My computer") and when you deploy the app to the PPC, you can automatically deploy the DB.sdf as well

Hope this helps you
By the way, this is not the best place to find answers to your questions about mobile devices, it looks like no one here pays atention to this part of codeproject.com Once i posted a problem i was having, and i never got an answer, actualy a had one (One of my own) since i found the answer somewhere else and decided to post it here

Alexei Rodriguez

Re: How to access the .sdf file's created in Pocket PC from compact framework emulator

Aasifkhan8-Nov-06 19:38

Aasifkhan

8-Nov-06 19:38

hi,
Alexei Rodriguez

Thanks for your help,but the problem is that i am working on VS.NET 2003,so these options will not be there.

As you told that this is not right place to get answers about PPC development then plz send me the links or forum link so that i can get the solutions.
Once Again Thanks for the help.........

Smile | :)

Re: How to access the .sdf file's created in Pocket PC from compact framework emulator

AlexeiXX39-Nov-06 6:53

AlexeiXX3

9-Nov-06 6:53

First look for an answer to your problem, maybe it is already there and if no luck, post in the section that best describes your problem:

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=11&SiteID=1[^]

I hope you can find an answer to your problem

Alexei Rodriguez

Transparency related issues

Manish19723-Nov-06 23:49

Manish1972

3-Nov-06 23:49

Hi

Platform: using VS2005 C# for WM5.0 base PDA

I am making one Bitmap button(owner draw). What i have done is i am
drawing
image on the button in onPaint() using e.drawimage ; I am also taking
care
that my bit map becomes transparent(all corners) . For the same i am
using
ImageAttributes attr = new ImageAttributes()
attr.SetColorKey(bmp.GetPixel(0,0), bmp.GetPixel(0,0));

In this case all the corners of my bitmap are becoming transparent and
showing same color(red color) which is my background color.(Here back
ground
is my application's main form which is having back color = red) .

Till this point every thing is ok .

My problem is " if i load an image on the main form " . In that case
above
bitmap buttons are still showing red color corner ...?? which is
correct only
in above case, but in this case when an image is loaded on the main
form ,Bit
map corners should display color of images which is loaded on the
form,but it
is still showing Red corner (which is the back color of main form.)

How can i get rid of this problem ..

Please help me ...

Regards
Manish Budhia

Sending message pc to mobile through Bluetooth

kumar bharat bhusanam3-Nov-06 19:15

kumar bharat bhusanam

3-Nov-06 19:15

I want to write a program in vb.net which sends message from pc to mobile. A bluetooth device is attached to the pc and message will send to mobiles ( whose bluetooth is enabled) when the mobile comes under the range of pcs bluetooth device.

welcome

Re: Sending message pc to mobile through Bluetooth

AlexeiXX37-Nov-06 18:08

AlexeiXX3

7-Nov-06 18:08

Check this link: http://msdn.microsoft.com/windowsmobile/downloads/videos/default.aspx[^] and search for the oe that says "Creating a Managed Bluetooth Application Using Microsoft Visual Studio 2005 (Level 200)"
I hope it helps you

Alexei Rodriguez

Name of the device

Talal Sultan2-Nov-06 21:56

Talal Sultan

2-Nov-06 21:56

Hi,

I was wondering if there was a way to know the name and make of the device the application is running on. I'm using compact framework 2.0 on windows mobile 5. I know we can get the OS version by calling Environment.OSVersion but that only gives WinCE and 5.xx.xx.
What I need is something like "Qtek", "HP", etc...
Is there a way to get that kind of info?

Thanks,
Talal

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook

Re: Name of the device

Mike Dimmick3-Nov-06 13:38

Mike Dimmick

3-Nov-06 13:38

Call SystemParametersInfo with the SPI_GETOEMINFO flag. See here[^] for how to declare SystemParametersInfo (replace user32 with coredll), and see WinUser.h (if I recall correctly) in the SDK to get the value of SPI_GETOEMINFO.

Stability. What an interesting concept. -- Chris Maunder

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.