How can I Read/Write CSV using .NET CF ??

[Neil Sutton via .NET 247]

Hi,

I am new to Visual Basic .Net (some experience with VB6) and I amtrying to write my first application for my PocketPC (WM2003) Ineed to be able to create/store/recall records like a database..but from some reading on a few websites it looks verycomplicated to do this with a .cdb file. From what I can see theeasiest way to do it is with a CSV file becuase then I canimport the CSV into excel on a desktop PC. I have no idea whereto start with opening/saving a CSV using the CF so that it willwork on my Pocket Pc. Could anyone post some sample code to helpme get started ??

Many Thanks

--------------------------------
From: Neil Sutton

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>fwW46fdKhEu Ge5sPqHyUtg==</Id>

[Cor Ligthert]

Hi Neil,

Did you already look what the XML dataset can do for you.
Probably that will be much easier.

Cor

[One Handed Man \( OHM - Terry Burns \)]

Here's some advice.

1.) Go and buy a book on ADO.NET
2.) Make a nice pot of coffee, sit at your PC and workthrough it.

. . . Three weeks later

3.) Join the ADONET newsgroup and start trying to give advice

In the meantime . . . .

DataBase storage and retreival in .NET is done using ADO.NET , which is
really just a set of closely related classed in the .NET framwork. This
allows you to connect to several database types.

ADO.NET is 'disconnected', in other words you request data, work on it, then
send it back. Probably different to what you are used to. In basic terms
this equates to a Connection Object Responsible for the actuall communicatin
to the database, the DataSet, which is where we store and work on our Data,
and in between these sits what's know as a DataAdapter. This manages the
communication between the Connection Object and the DataSet ( Data Store ).

It sounds daunting, but its not that bad really, only you get to grips with
it its quite simple in the main, although certain things can be tricky.

HTH - OHM ( Terry Burns )





"Neil Sutton via .NET 247" <an*******@dotn et247.com> wrote in message
news:um******** ******@tk2msftn gp13.phx.gbl...
Hi,

I am new to Visual Basic .Net (some experience with VB6) and I am trying to
write my first application for my PocketPC (WM2003) I need to be able to
create/store/recall records like a database.. but from some reading on a few
websites it looks very complicated to do this with a .cdb file. From what I
can see the easiest way to do it is with a CSV file becuase then I can
import the CSV into excel on a desktop PC. I have no idea where to start
with opening/saving a CSV using the CF so that it will work on my Pocket Pc.
Could anyone post some sample code to help me get started ??

Many Thanks

--------------------------------
From: Neil Sutton

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>fwW46fdKhEu Ge5sPqHyUtg==</Id>

[Ken Tucker [MVP]]

Hi,

http://www.onteorasoftware.com/downloads/csvtest.zip

Ken
-----------------

"Neil Sutton via .NET 247" <an*******@dotn et247.com> wrote in message
news:um******** ******@tk2msftn gp13.phx.gbl:

Hi,

I am new to Visual Basic .Net (some experience with VB6) and I am trying
to write my first application for my PocketPC (WM2003) I need to be able to
create/store/recall records like a database.. but from some reading on a few
websites it looks very complicated to do this with a .cdb file. From what I
can see the easiest way to do it is with a CSV file becuase then I can
import the CSV into excel on a desktop PC. I have no idea where to start
with opening/saving a CSV using the CF so that it will work on my Pocket Pc.
Could anyone post some sample code to help me get started ??

Many Thanks

--------------------------------
From: Neil Sutton

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>fwW46fdKhEu Ge5sPqHyUtg==</Id>

--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.230 / Virus Database: 263.3.0 - Release Date: 6/12/2004

[The Grim Reaper]

Download the PocketPC Compact Framework SDK v1.1 from Microsoft.com.

Plenty of examples and details in there, all CF specific.
_______________ _______________ _________
The Grim Reaper

"Neil Sutton via .NET 247" <an*******@dotn et247.com> wrote in message
news:um******** ******@tk2msftn gp13.phx.gbl...
Hi,

I am new to Visual Basic .Net (some experience with VB6) and I am trying to
write my first application for my PocketPC (WM2003) I need to be able to
create/store/recall records like a database.. but from some reading on a few
websites it looks very complicated to do this with a .cdb file. From what I
can see the easiest way to do it is with a CSV file becuase then I can
import the CSV into excel on a desktop PC. I have no idea where to start
with opening/saving a CSV using the CF so that it will work on my Pocket Pc.
Could anyone post some sample code to help me get started ??

Many Thanks

--------------------------------
From: Neil Sutton

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>fwW46fdKhEu Ge5sPqHyUtg==</Id>