By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,165 Members | 1,429 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,165 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 20 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
"What-a-Tool" <Fr***********************@cox.net> wrote in
news:bD69b.60484$Zw4.56385@lakeread03:
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.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 20 '05 #2

P: n/a
Hello,

"What-a-Tool" <Fr***********************@cox.net> schrieb:
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/microsof...amework.adonet

Web interface:

http://msdn.microsoft.com/newsgroups...amework.adonet

--
Herfried K. Wagner
MVP VB Classic, VB.NET
http://www.mvps.org/dotnet
Nov 20 '05 #3

P: n/a
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?

"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn**************************@140.99.99.130...
"What-a-Tool" <Fr***********************@cox.net> wrote in
news:bD69b.60484$Zw4.56385@lakeread03:
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.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

Nov 20 '05 #4

P: n/a
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
Nov 20 '05 #5

P: n/a
Hello,

"Fergus Cooney" <fi******@tesco.net> schrieb:
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?


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...

;-)

--
Herfried K. Wagner
MVP VB Classic, VB.NET
http://www.mvps.org/dotnet
Nov 20 '05 #6

P: n/a
"What-a-Tool" <Fr***********************@cox.net> wrote in
news:SEB9b.64780$Zw4.48304@lakeread03:
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.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 20 '05 #7

P: n/a
Thanks people - appreciate the responses and help.
Sean

"What-a-Tool" <Fr***********************@cox.net> wrote in message
news:bD69b.60484$Zw4.56385@lakeread03...
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.

Nov 20 '05 #8

P: n/a
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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 20 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.