Newbie mobile example needed

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
classicmydac
Posts: 38
Joined: Fri 23 Dec 2005 11:51

Newbie mobile example needed

Post by classicmydac » Mon 05 Jun 2006 14:16

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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 06 Jun 2006 06:22

Please take a look on a "Pictures" demo project in our samples.

classicmydac
Posts: 38
Joined: Fri 23 Dec 2005 11:51

Pictues demo

Post by classicmydac » Fri 09 Jun 2006 16:25

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.

classicmydac
Posts: 38
Joined: Fri 23 Dec 2005 11:51

Got it thanks.

Post by classicmydac » Mon 12 Jun 2006 09:23

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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 13 Jun 2006 06:37

You should configure SelectCommand property of the MySqlDataAdapter component so that it would return only one record.

Post Reply