Re: Using ADO with data from a binary file
- From: "Ralph" <nt_consulting64@xxxxxxxxx>
- Date: Tue, 27 Sep 2005 23:27:21 -0500
<sam.s.kong@xxxxxxxxx> wrote in message
news:1127865491.475215.9530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello!
>
> I have been assigned to a small project which implements a program that
> imports data from other applications to our DB (Access).
> Some data are *.dbf so no problem.
> But some are custom binary files that I need to parse.
> Users will select rows to import.
>
> Is there are way that I can bind the data from a custom file to ADO so
> that I can show the data in a data-bound datagrid without saving the
> data into a database?
>
> Similarly, it there a way to bind an array of structures to db-control?
> (Basically this is the same question as the first one, I guess).
>
> Thanks in advance.
>
> Sam
>
We are talking about VB6 and not .net, correct?
If so the answer is Yes. depending on how much 'work' you want to do.
Taking the last question first. It is very easy to create your own
DataSource to bind to any control that takes a 'datasource'. Look up "Data
Aware Classes" in the MSN Help. Also take a look at the "MS Data Binding
Collection".
You can then modify this 'class' to do anything you want. For example it
could read in a file, prepare its own collection, or recordset - and then
make the data available as a 'datasource'.
So to answer your first question, you wouldn't 'bind' a custom layout to
ADO, you would create a "Datasource" that would provide data just like ADO.
hth
-ralph
.
- References:
- Using ADO with data from a binary file
- From: sam . s . kong
- Using ADO with data from a binary file
- Prev by Date: Calling connection string wizard from VB.NET
- Next by Date: Re: Adding and retrieving MS Word documents in Access (via VB)
- Previous by thread: Using ADO with data from a binary file
- Next by thread: Calling connection string wizard from VB.NET
- Index(es):
Relevant Pages
|