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. 8 4381
"What-a-Tool" <Fr************ ***********@cox .net> wrote in
news:bD69b.6048 4$Zw4.56385@lak eread03: 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********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying. http://members.ebay.com/aboutme/coolspot18/
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********@rog ers.com> wrote in message
news:Xn******** *************** ***@140.99.99.1 30... "What-a-Tool" <Fr************ ***********@cox .net> wrote in news:bD69b.6048 4$Zw4.56385@lak eread03:
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********@rog ers.com) Please delete "REMOVE" from the e-mail address when replying. http://members.ebay.com/aboutme/coolspot18/
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
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
"What-a-Tool" <Fr************ ***********@cox .net> wrote in
news:SEB9b.6478 0$Zw4.48304@lak eread03: 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********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying. http://members.ebay.com/aboutme/coolspot18/
Thanks people - appreciate the responses and help.
Sean
"What-a-Tool" <Fr************ ***********@cox .net> wrote in message
news:bD69b.6048 4$Zw4.56385@lak eread03... 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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David Steward |
last post by:
When looking at the help files for datagrid I see a lot
of information for how to data bind the datagrid to a
database. The help information mentions that data binding
can be done also to an array, but gives no further
information than that. How would I set up a data binding
to an array? Would this be a .net array? How is the array
configured?
Thanks,
|
by: Alan Silver |
last post by:
Hello,
I'm trying to use an ArrayList to do data binding, but am getting an
error I don't understand. I posted this in another thread, but that was
all confused with various other problems, which could be why no-one
answered it!! I've now narrowed the problem down, so am starting a new,
more specific, thread. Sorry it's a bit long, but it's reasonably simple
stuff.
I have a page where I'm showing product details, including any
|
by: Larry Serflaten |
last post by:
I am not sure how many are aware of this sort of data binding,
but as it is new to many (classic) VB developers I thought I
would post this once just to let people know of its availablility.
There are cases where properties of one object is dependant on
a property of another object. For a common example, when you
bind an ArrayList to a ComboBox using the combo's DataSource
property, the combo box fills up with items from the array list....
|
by: mark |
last post by:
I understand that writing programs with option strict on is the best way to
obtain stable applications. I have also found the applications to run much
faster.
Option strict on disallows late binding, so if I have an array with class
level scope and I am operating on that array at procedure level I fabricate a
"dummy array" and copy the class level array into it. Then after performing
the task I can copy the "dummy array" back into the...
|
by: lgbjr |
last post by:
hi All,
I've decided to use Options Strict ON in one of my apps and now I'm trying
to fix a late binding issue. I have 5 integer arrays:
dim IA1(500), IA2(500), IA3(500), IA4(500), IA5(500) as integer
The integers in these arrays are actually pointers to different columns of
data in a text file.
| |
by: kin |
last post by:
After a I read Walkthrough: Connecting to Data in Objects
(http://msdn2.microsoft.com/en-us/library/ms171892.aspx#Mtps_DropDownFilterText).
I still have project on that.
My School project provided me an array of objects - News, but VS 2005 seams
only accept Collections like IList<News> for DataBinding.
I can convert an array to IList<News> list = (IList<News>)news, but IList is
not a class, so I tried to create a class that extends...
|
by: A. Spiehler |
last post by:
I'm trying to fill a listBox control with string members from an array
of objects. I think using data binding is supposed to be the easiest
way to do this. I've never used data binding before and am having
trouble getting it to do anything. The relevant code is below, followed
by a better explanation of what I'm trying to do.
// pseudocode start
public delegate string StepMethod();
|
by: Miro |
last post by:
VB 2003 and Im still new to vb, so i hope i can explain this as best I can.
I have a variable defined as such: ( simple example )
Dim AVariableOfSorts(,) As Object = _
{ _
{"Last", "String", 20}, _
{"First", "String", 20} _
}
|
by: kevinwolfe |
last post by:
Hi all.
I'd like any suggestions on how I can get my data set (not a DataSet)
bound to a couple of controls on a form. Let me start by describing
what my data looks like. Each entry correlates to a piece of equipment
and has the following information:
Two strings, one for a system name and one for equipment name
An integer
An ArrayList (which will contain only strings)
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |