Page 1 of 1

Newbie mobile example needed

Posted: Mon 05 Jun 2006 14:16
by classicmydac
Do anyone have a simple example to do the following:

Visual studio 2005 C# windows mobile 2005(pocket pc):

I have a listbox with data in each line as follows:

item1,item2,item3,item4,pathtoJPG

I need to open a mysql table and copy over the data and jpegs. Once copied delete the data from the device.

Cheers

SteveW

Posted: Tue 06 Jun 2006 06:22
by Alexey
Please take a look on a "Pictures" demo project in our samples.

Pictues demo

Posted: Fri 09 Jun 2006 16:25
by classicmydac
I have sample data stored in a Memobox. This contains various fields and paths to images.

I need step through the data from the memobox, insert a new record, copy the fields and image into the table.


Do you have simple sample code to do the following:

On a button click insert a new record into the grid.
set one Name field to "test"
copy "my document\my picture\001.jpg" to the picture field.

Any help or pointers appreciated.


Cheers

SteveW.

Got it thanks.

Posted: Mon 12 Jun 2006 09:23
by classicmydac
I am now using the Pitcures example and it is working as expected.

I now need to connect to the existing database which contains thousands of records.

If I use the fill command it takes too long to as it copies all the data over. How can I simply fill the grid with the last record in the table. (I then need to add my new records to the existing tables).

Any help appreciated

SteveW

Posted: Tue 13 Jun 2006 06:37
by Alexey
You should configure SelectCommand property of the MySqlDataAdapter component so that it would return only one record.