ADO or ADOn't, binding data to an array?

[What-a-Tool]

I have an array (2 Dimensional) which has been filled from a text file and
want to load
these several hundred fields into my db, which consists of 3 tables(each of
which will be receiving a portion of this data)
I also want to be able to do the reverse > load my db into an array for
processing into a report.

I've worked with several textbook examples of ADO.Net programs to manipulate
data within an Access db, but I haven't found anything that covers what I am
trying to do now, other than a few hints that yes, a dataset can be bound to
an array.

Can anyone give me a hint as to how to go about doing this?Using ADO.Net, as
mentioned above.

 

[Lucas Tam]

I've worked with several textbook examples of ADO.Net programs to
manipulate data within an Access db, but I haven't found anything that
covers what I am trying to do now, other than a few hints that yes, a
dataset can be bound to an array.

Do you have to use an array? It is much easier to do this with a dataset or
datatable.

 

[Herfried K. Wagner [MVP]]

Hello,

Can anyone give me a hint as to how to go about doing
this?Using ADO.Net, as mentioned above.

This is a VB.NET language group. Notice that you will have a better
chance to get an answer if you post to the ADO.NET newsgroup in future:

news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet

Web interface:

http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet

 

[What-a-Tool]

Data Tables - Interesting things!
Been cramming through Ado.Net - Step by step since I decided to try my hand
at this project (just a personal learning project) using ADO. Just got to
the section on Data tables and data viewers, and I see your point.
By the way - I did post this on the ADO news group. I didn't get a response.
Theres more action in this group, and the subjects are related, aren't they?

 

[Fergus Cooney]

Hi Herfried,

|| This is a VB.NET language group. Notice that you will have
|| a better chance to get an answer if you post to the ADO.NET
|| newsgroup in future:

ROFL

Did you read What-a-Tool's 11:32am response?

|| By the way - I did post this on the ADO news group.
|| I didn't get a response. Theres more action in this group,
|| and the subjects are related, aren't they?

What-a-Tool - it's 'cos we're a nicer bunch over here, that's why. Related
or not, if help is possible, help is given - despite the best efforts of the
police to redirect the traffic, lol. :-D

Regards,
Fergus

 

[Herfried K. Wagner [MVP]]

Hello,

ROFL

Did you read What-a-Tool's 11:32am response?

I read it now. The problem is that everybody posts the ADO.NET related
questions to the language groups. That's why there is few traffic in the
ADO.NET group.

What-a-Tool - it's 'cos we're a nicer bunch over here,
that's why. Related or not, if help is possible, help is given

ACK. If someone has an answer, he is free to post it here.

- despite the best efforts of the police to redirect the traffic,
lol. :-D

Nobody wants to redirect traffic...

;-)

 

[Lucas Tam]

Data Tables - Interesting things!
Been cramming through Ado.Net - Step by step since I decided to try my
hand at this project (just a personal learning project) using ADO.
Just got to the section on Data tables and data viewers, and I see
your point. By the way - I did post this on the ADO news group. I
didn't get a response. Theres more action in this group, and the
subjects are related, aren't they?

m.p.d.l.vb seems to have more traffic than the ADO.NET group. Anyhow,
yes, ADO.NET and VB.NET are related.

However, ADO and ADO.NET are two totally different things. ADO is
Microsoft's older Data Access layer while ADO.NET is the the new version
for .NET. ADO.NET has significant changes and has hardly any resemblence
to ADO.

I suggest that you bind objects to a data table instead of an array
because DataTables provide much more rich functionality such as Sorting,
Views, etc. Also, when binding to a DataTable to a control, you can
easily specify the displaymember and valuemember columns. I believe if
you want to specify displaymember/valuemember columns with an array you
need to create a new class object and that takes much more code.

Arrays are probably easier on memory, but the advantages of the datatable
are definately worth the tradeoff in my mind.

 

[What-a-Tool]

Thanks people - appreciate the responses and help.
Sean

 

[Ravichandran J.V.]

Easier is a Collection.

with regards,


J.V.Ravichandran
- http://www.geocities.com/
jvravichandran
- http://www.411asp.net/func/search?
qry=Ravichandran+J.V.&cob=aspnetpro
- http://www.southasianoutlook.com
- http://www.MSDNAA.Net
- http://www.csharphelp.com
- http://www.poetry.com/Publications/
display.asp?ID=P3966388&BN=999&PN=2
- Or, just search on "J.V.Ravichandran"
at http://www.Google.com