Accessing a local database from C#

J

Juan

Hi everyone,

I am pretty new to C# developing form mobile devices. I have an Access
database that I have syncronised through ActiveSync to my PocketPc. Now,
using VS.NET 2003 I want to develop a simple app that retreives data from
the database.

Is this possible at all, or do I need SQL CE server? Where can I find this
server?

Are there any samples on how to acess an Access database?

Thanks, from Spain
 
J

Juan

Sorry, I should have looked more carefully... I already know where to get
ahold of SLQ CE.

But I still don´t know how to use my Access imported Databases.
Juan wrote:
:: Hi everyone,
::
:: I am pretty new to C# developing form mobile devices. I have an
:: Access database that I have syncronised through ActiveSync to my
:: PocketPc. Now, using VS.NET 2003 I want to develop a simple app that
:: retreives data from the database.
::
:: Is this possible at all, or do I need SQL CE server? Where can I
:: find this server?
::
:: Are there any samples on how to acess an Access database?
::
:: Thanks, from Spain
 
C

Chris Tacke, eMVP

There is no inherent Pocket Access class library. InTheHand has one.

-Chris
 
J

Juan

If it´s not supported by .Net framework, what's the point on having Access
databases in the Pocket PC? You can´t open them, not even programatically???
I don´t understand.....

Peter Foot [MVP] wrote:
:: Pocket Access is not supported directly by the .NET Compact
:: Framework, however you can use the ADOCE control by creating a
:: wrapper to handle interop with the COM control (.NETCF has no built
:: in COM/ActiveX interop). We produce such a wrapper, there is an
:: example of it's use in this article:-
::
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road10222003.asp
::
:: Peter
::
:: --
:: Peter Foot
:: Windows Embedded MVP
:: OpenNETCF.org Senior Advisor
:: www.inthehand.com | www.opennetcf.org
::
:: ::: Sorry, I should have looked more carefully... I already know where
::: to get ahold of SLQ CE.
:::
::: But I still don´t know how to use my Access imported Databases.
::: Juan wrote:
::::: Hi everyone,
:::::
::::: I am pretty new to C# developing form mobile devices. I have an
::::: Access database that I have syncronised through ActiveSync to my
::::: PocketPc. Now, using VS.NET 2003 I want to develop a simple app
::::: that retreives data from the database.
:::::
::::: Is this possible at all, or do I need SQL CE server? Where can I
::::: find this server?
:::::
::::: Are there any samples on how to acess an Access database?
:::::
::::: Thanks, from Spain
 
C

Chris Tacke, eMVP

You can use eVC just fine, there's just no managed provider. The "point" of
having it is for backward compatibility. Pocket Access as a data engine
will become obsolete in a future version of Pocket PC.
 
J

Jamie Macleod

So... what will the data engine be?

Chris Tacke said:
You can use eVC just fine, there's just no managed provider. The "point" of
having it is for backward compatibility. Pocket Access as a data engine
will become obsolete in a future version of Pocket PC.

--
Chris Tacke, eMVP
Co-Founder and Advisory Board Member
www.OpenNETCF.org
---
Windows CE Product Manager
Applied Data Systems
www.applieddata.net



http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road10222003.asp
Click to expand...
 
J

Juan

So I'd be better off using XML or SQL as a data provider...

Thanks for the explanations, some stuff is pretty obscure for me...

Chris Tacke, eMVP wrote:
:: You can use eVC just fine, there's just no managed provider. The
:: "point" of having it is for backward compatibility. Pocket Access
:: as a data engine will become obsolete in a future version of Pocket
:: PC.
::
:: --
:: Chris Tacke, eMVP
:: Co-Founder and Advisory Board Member
:: www.OpenNETCF.org
:: ---
:: Windows CE Product Manager
:: Applied Data Systems
:: www.applieddata.net
::
::
:: ::: If it´s not supported by .Net framework, what's the point on having
::: Access databases in the Pocket PC? You can´t open them, not even
::: programatically??? I don´t understand.....
:::
::: Peter Foot [MVP] wrote:
::::: Pocket Access is not supported directly by the .NET Compact
::::: Framework, however you can use the ADOCE control by creating a
::::: wrapper to handle interop with the COM control (.NETCF has no
::::: built in COM/ActiveX interop). We produce such a wrapper, there
::::: is an example of it's use in this article:-
:::::
:::
::
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road10222003.asp
:::::
::::: Peter
:::::
::::: --
::::: Peter Foot
::::: Windows Embedded MVP
::::: OpenNETCF.org Senior Advisor
::::: www.inthehand.com | www.opennetcf.org
:::::
::::: :::::: Sorry, I should have looked more carefully... I already know
:::::: where to get ahold of SLQ CE.
::::::
:::::: But I still don´t know how to use my Access imported Databases.
:::::: Juan wrote:
:::::::: Hi everyone,
::::::::
:::::::: I am pretty new to C# developing form mobile devices. I have an
:::::::: Access database that I have syncronised through ActiveSync to
:::::::: my PocketPc. Now, using VS.NET 2003 I want to develop a simple
:::::::: app that retreives data from the database.
::::::::
:::::::: Is this possible at all, or do I need SQL CE server? Where can
:::::::: I find this server?
::::::::
:::::::: Are there any samples on how to acess an Access database?
::::::::
:::::::: Thanks, from Spain
 
J

Juan

I might as well... I guess I´ll decide when I see the amount of data to be
handled.

Jamie Macleod wrote:
:: If it's as simple database you may just want to use CSV files
::
:: ::: So I'd be better off using XML or SQL as a data provider...
:::
::: Thanks for the explanations, some stuff is pretty obscure for me...
:::
 
M

Microsoft MVP Jan Yeh for Windows CE .NET

Data size is a key issue to use XML file as data source.
When you read from XML file will take much more time than
writting to it.

You can try yourself for experiment.

--
Best Regards,
Jan Yeh

MVP(Windows CE.NET), MCAD, .NETcf Developer & Consultant
Mobile Mind Co., Ltd. @ Taiwan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL CE Synchronization 3
IPC method to use 16
Starting a C# application does nothing...then native exception 2
How to make a local database 8
Db connection 3
ActiveSync, or write own provider? 7
CF 2.0 multithread app accessing database 12
PDA to SQLServer 8

Top