Re: Filling a DataSet from a positionally delimited flat file
From: billym (nfr_at_nospam.com)
Date: 04/16/04
- Next message: Robert Pfeffer: "RE: Repost of ODBC Transaction Problem"
- Previous message: Mary Chipman: "Re: Oledb* Or SQL* classes"
- In reply to: Alex: "Re: Filling a DataSet from a positionally delimited flat file"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 16 Apr 2004 07:37:40 -0700
I created a class that can populate a DataSet from a positionally delimitted
file based on info in a Cobol copybook... but was curious about the
statement in The Code Project that seemed to indicate this was not
necessary.
BizTalk has good support for flat files, but this will not work in my case
insofar as I am building a Tablet PC application and BT would be overkill.
"Alex" <alexware69@hotmail.com> wrote in message
news:%23acYDt0IEHA.3964@TK2MSFTNGP10.phx.gbl...
> Hi. I think you first need to determine the structure of stored data and
> then you can construct a DataSet around it using
> System.IO.StreamReader to read the file and System.String to get the
> appropriates substrings.
>
> I don't know of other Data Providers than OleDb , ODBC, SQL and Oracle. at
> least not from Microsoft.
>
> alex.
>
>
> "billym" <nfr@nospam.com> wrote in message
> news:OQyH3wvIEHA.3032@TK2MSFTNGP09.phx.gbl...
> > An article in the The Code Project entitled "A simple architecture to
read
> > arbitrarily formatted flat files into ADO DataSets" had the following
> > comment:
> >
> > "There are Ole Providers to read formatted flat files into DataSets, but
> > ever wondered about importing data from files which are not simply comma
> > delimited or tab delimited (not columnar) but some native format."
> >
> > Does anyone have a link to information on these providers? (All of my
> > reference material only shows how to access databases such as SQL
Server,
> > Oracle, Access, etc.)
> >
> >
>
>
- Next message: Robert Pfeffer: "RE: Repost of ODBC Transaction Problem"
- Previous message: Mary Chipman: "Re: Oledb* Or SQL* classes"
- In reply to: Alex: "Re: Filling a DataSet from a positionally delimited flat file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
