Re: Help needed on Array's

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance




Hi Nathan,

The function I need to write, will i suppose depend on how i store the data,
be in an array or arraylist. The function will need to read through the array
/ array list starting at index 0 . I will get the three parts of information
and then parm the data to a SQL Stored Procedure. I am intending to step
through the array / arraylist index untill there array(index) value is empty.

Hope that makes sense

"Nathan Sokalski" wrote:

Another thing that may affect what you want is the type accepted by the
function you say you want to pass it to (would you be able to give us the
signature of the function?). If you plan to write this function yourself,
then it probably won't make much of a difference.
--
Nathan Sokalski
njsokalski@xxxxxxxxxxx
http://www.nathansokalski.com/

"Peter Newman" <PeterNewman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B840A1E9-C91B-449B-9171-8BECA3E3843B@xxxxxxxxxxxxxxxx
Hi PvdG42
Thanks for the reply,

The language is vb.net 2005. The data types are strings , Name, Company ,
Service and it would be simpler if they were stroed in that order, and
will
be acc accessed sequentially from the beginning of the collection. As far
as
the file goes, there will be a mimimum of 1 record in the file, with an
esitmated maximum of about 200. I hope this helps in being able to give
advice and examples of the best way to handle this

regards
"PvdG42" wrote:



"Peter Newman" <PeterNewman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:32B19292-4101-469D-B6B6-FFDEEDC43BC4@xxxxxxxxxxxxxxxx
VS2005, vb.net 2005 & SQL2005

Dispite reading various web pages, i am still confused and stuck.
I am looping in a flat file and extracting 3 peices of information per
line
Name, Company , Service
the file will contain at least 1 line but an unlimited maximum lines.
What
i need to do is load the information into an array / ArrayList to be
able
to
parm it to a function

I have looked at arraylist and structures, but to be honest im still
just
as
baffled. Can any one provide an example and explination?

What language are you using? You ask for examples, and it would make
sense
if any examples provided were in the language you are using.

The ArrayList class defines a collection that can expand to hold any data
you want to store in it, so (compared to an Array, as you only mentioned
those two collections) that makes it a better choice for your needs as
you've described so far.

Yes, a struct may well be a good choice for your three fields. When you
define a struct, you are defining a new type to your language compiler,
so
you can then create an ArrayList that holds multiple instances of your
new
type.

What datatype are each of the three fields you want to store? How will
the
sets of fields you want to use as arguments be stored in your collection?
Any particular order? How will the field sets be accessed for method
calls?
Sequentially from the beginning of the collection?

All these questions need to be answered if you hope to get any good
examples.

Unlimited records on the input file? You must have some idea of the
potential high limit. If the number of records is really potentially
huge,
that too will influence what makes sense as a solution design.







.



Relevant Pages

  • Re: efficiency of && vs. array
    ... language which is loosely based on C. as such, ... it occured to me that i could store a, b, c, and d in an array and use ... I am the "ILOVEGNU" signature virus. ...
    (comp.lang.c)
  • Re: Finding the nearest match without reusing results
    ... comparing an array with a value generates an array of Trues and ... Any diff with wrong State or with used Store is implicitly zeroed out. ... Each must be larger than the absolute value of the maximum Sales ... go.....it just needs to return the closest match. ...
    (microsoft.public.excel.programming)
  • Re: [patch 3/4 -mm] flex_array: poison free elements
    ... character as the poison value. ... If someone ever tried to store strings ... I wasn't aware that storing an array of ASCII characters was a use case ... distinguish when the elements are being stored in struct flex_array vs. ...
    (Linux-Kernel)
  • Re: Help needed on Arrays
    ... The language is vb.net 2005. ... you want to store in it, so (compared to an Array, as you only mentioned ... a struct may well be a good choice for your three fields. ... What datatype are each of the three fields you want to store? ...
    (microsoft.public.vsnet.general)
  • Re: read keyboard input and storing in an array?
    ... > I'm trying to store user input in an array, ... You have the beginnings of that logic already since your prompt tells the ... 201st value since the array only has room for 200 values. ... This will force you to store the int values as Integer ('Integer' ...
    (comp.lang.java.help)