Intelligently Compare Arrays With .NET 2.0?

Dec 28, 2011

I am trying to make an intelligent stock pick/dispatch location system at the point of invoice from a stock database. Multiple locations are available to dispatch from, and essentially I want to make efficient dispatch, so if all items purchased can be dispatched from one location, they are grouped and dispatched as such, but if not, it groups what it can and dispatches the rest from wherever the highest stock level is available.Because the number of locations has to be variable, this system is scalable.Because the number of items is also scalable So, instead of listing suitable stock locations, I am now listing the quantity of stock available in each location for the respective items.

Items Locations
_________|__1___|___2__|__3__| - this is location IDs
Item 1 | 3 , 4 , 1 - this is the qty of stock available

[code]....

I can turn this into a string which might be used to split and create arrays

ie
stockDetails = "3,4,1|2,4,0|1,3,1|6,1,3"

Here, the comma separated values are quantity of available stock in each stock location and the pipes separate the individual items, so the table above is translated to the string above.I am not keen on multi-dimensional arrays and don't know how I'd create one without knowing how many stock locations there are.

We can safely assume That the stock quantities are in the correct order to correlate back to the stock locations IDs.
Each pipe separate series of comma separated values will have the same number of comma separated values.I just can't work out how to determine the pick locations! In the above example, all four items can actually be picked from stock location 1, providing only one of each item is purchased. Suppose though a customer bought 2 of item 3. Then the pick would have to be from location 2. All kinds of other scenarios can of course be presented depending on the number of items purchased, the quantity of items purchased and how many stock locations there are to pick from.I started off simply picking from the location with the highest available stock, but that made no sense when stock was available to pick from more than one locaton because we ended up with multiple dispatch locations which was not necessary.How can I analyse these variable length strings/arrays to determine the most intelligent way to dispatch.

View 2 Replies


ADVERTISEMENT

Compare 2 Arrays Without Looping?

Nov 29, 2011

Is it possible to compare 2 arrays without looping? For this example, I need to compare aryFi.Count to currentarraycount. if aryFI.count>currentarraycount, then I need to add the ones in aryFi.count into a public array named pgarraylist. Since aryFi contains more items, I can't just take the .count-the difference in counts, I need a way to get the items contained in aryFi but not in currentarraycount. EDIT - currentarray is the list of currentarraycount Sounds confusing - but here's an example.

Public pgarraylist As New ArrayList
Dim aryFi As IO.FileInfo() = di.GetFiles("*.xls")
cntdif = aryFi.Count - currentarraycount 'currentarraycount is updated after changes occur and when loading program.
For y = cntdif To 1 Step -1

[code]....

View 2 Replies

Compare Two Arrays, Bytes?

Aug 13, 2009

How can i compare two arrays like :

Dim Ar1,Ar2 as array
Ar1 = My.Computer.FileSystem.ReadAllBytes("C:Try.mp3")
Ar2 = My.Computer.FileSystem.ReadAllBytes("C:Try1.mp3")

how can i compare that two?

View 6 Replies

Compare Two Byte Arrays?

Mar 9, 2009

I am trying to compare two long bytearrays in vb.net and have run into a snag. Comparing two 50 meg files takes almost two mins so I'm clearly doing something wrong. I'm on an x64 machine with tons of memory so there are no issues there. Here is the code that I'm using at the moment and would like to change.[code]...

View 5 Replies

VS 2010 How To Compare Arrays

Jun 12, 2012

I'm trying to determine the highest customers in a single month of the year. I also need to add the corresponding month to that.

View 4 Replies

Arrays - Compare Two Lists 2D And Determine

May 2, 2012

I declare my 2D lists:

Dim _invoiceitems As New List(Of List(Of String))
Dim _dbitems As New List(Of List(Of String))

Each List is filled like this: Example Code To fill:

_invoiceitems.Add(New List(Of String))
_invoiceitems(0).Add("Code #")
_invoiceitems(0).Add("Quantity")

Well, now i need a third list called (_changesitems) Note that this result with the differences: be the result of subtraction of quantities if this is found (dbitems - invoiceitems).

View 1 Replies

C# - Compare/sort Items From Two Arrays?

Jul 16, 2009

I have a question about efficient implementation. Lets say I have two arrays:

One array is all possible items in a house: Table, Chair, TV, Fireplace, Bed

The other is an array of items in a particular house: Table, TV, Bed

I also have two list boxes:

1. listbox for items in the house - the "HAS" list box
2. listbox items not in the house - the "NEEDS" list box

I need to list the items already in the house in the "HAS" list box as well as the items that are NOT in the house in the "NEEDS" list box. It seems to me that nested "For each" loops would be a start to solving this problem but I am not exactly sure which case needs to be nested.

View 2 Replies

VS 2010 Two Separate Arrays And Then Compare Them?

Jul 2, 2011

I want to put the matches from a regular expression into an array or something that i can use to compare it with another array, it being the lines from a txt file names "users.txt". Code A:

[Code]...

And the second code will do the exact same thing. What i want to do is compare each line in the Txt file (Code B) to the reg expression matches (Code A) and for it to alert me if any is missing. So it needs to compare Code B to Code A. (PS. Order is irrelevant, it can be in different places as long as its there) In my other thread i got a little confused and couldn't clearly communicate what i was trying to do.

View 32 Replies

Compare Arrays And Listboxes Values In VB 2010

Jul 22, 2011

I have a program that has to store a pre-made array that contains strings (moviename, moviegenre).

I setup all the items in the array already, example:

moviearray(0,0) = "Green Lantern"
moviearray(0,1) = "Action"

For this example, if the user selected "Green Lantern" from my listbox, then the label needs to display "Action". So yeah, it's a 2-column array: first column = movie name, 2nd column = movie genre. Now, I have a listbox containing all of the movie names (not entered by the array, but entered through the Item property of the listbox). When a selection is made in the listbox and a button is clicked, I need to have the genre of the movie output to a label. That is where I am stuck, I just can't figure out to compare what's in the list box with the first column of the array to output the 2nd column to the label.

View 15 Replies

Compare Two Arrays And Remove Matched Item?

Jan 13, 2010

i have tese two arrays

if i find filter_ids in stroutids i want to remove those from stroutids array
Dim strOutIDs() As String = Split(OutIDs, ",")
Dim Filter_Ids() As String = Split(Me.ucIo_Entry.Filterd_RowIds, ",")

[Code]...

View 2 Replies

Compare Date - Compare Textbox1 And Textbox2 Text

Mar 3, 2010

I have two textbox in my application.

Textbox1.Text="19-Jan-2010"

Textbox2.Text="Jan 2010"

May I know how can I compare that Textbox1 and Textbox2 text is within same month and same year?

View 1 Replies

VB6 Used Recordsetsor Arrays - .Net Framework In VB2010. Datasets, Dataviews. Tableadapters, Arrays. Enums ?

May 9, 2010

In VB6 I load a recordset containg all of the records (6 fields per record)in a table into an XArray and then manipulate the records in the array and then write them back to the original table. The array issorted by the first field (1 to maybe 8000 or more) I need to find records in the array by an ID field and then move them (because of some external criteria that happens many times) from say number 400 to number 375. Then all of the other records between 375 and 399 were renumbered up 1 to fill the gaps left by the move.

The XArray worked well as it could find and also move to a next record easily to facilitate the revisions to each record quickly. Everything is done in VB6 in code and nothing visual needs to be shown to the user until say 2000 of these external changes are complete. What is the best, most efficient way to do this in the .Net framework in VB2010. Datasets, Dataviews. tableadapters, arrays. enums ?

View 3 Replies

Integer Arrays - User Enter In Big Integers Using - Two Parallel Arrays

Dec 10, 2009

My assignment is to have a user enter in big integers using what i think is two parallel arrays. I got this far but now im stuck. I think i need to actually convert the text box input into an array but i do not know how to do that. I am all over the place in this project.

'Created/ Revised by: Jessica Falcetta
'Cap 204 Final Project: Big Integer Project
'Project Purpose: To calculate large integers through parallel arrays

[CODE]...

View 5 Replies

Passing Arrays Through Fortran Dll From App Turning To Single Element Arrays?

Feb 2, 2010

I have a VB.net console app and I am opening a function in a dll written in fortran. I am passing 3 arrays through the function by reference. When they come back out the otherside they ahve all tunred to arrays of only one element And that element is 0.I read on the internet somewhere that when doing this kind of thing it is a good idea to only pass the first element of the array into the function.I tried changing my function declaration to accepting single elements rather than single dimensional arrays, and now the arrays are the same length before and after the function call, but they don't seem to be changing at all, so i'm not sure that this is working

View 1 Replies

VS 2008 Arrays Displaying States/searching Arrays?

Oct 30, 2010

the statement Dim state(49) As String and maintain a list of certain states. The list of states should always be in alphabetical order and occupy consecutive elements of the array. The buttons in the program should give the user the following options: (a) Take the state specified by the user in a text box and insert it into its proper position in the array. If the state is already in the array, so report. (b) Take the state specified by the user in a text box and delete it from the array. If the state is not in the array, so report. (c) Display the states in the array. "

Private Sub states_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
state(0) = "Alabama"

[code]....

View 1 Replies

Comparing Arrays :: Possible Without Iterating The Arrays?

May 3, 2010

I was wondering if anyone knows a built in method ( LINQ say or a LAMBDA expression or other way ) that you can compare2 arrays - collections that would be valid for an equivalent 3rd array - collection which is a combination of the 1st two.

As an example consider;
* * *
A L E

[code].....

View 17 Replies

Sort Three Arrays (the Other Two Arrays Are In Sync With The First)?

Oct 13, 2009

How can I sort three arrays so they are sorted together (the other two arrays are in sync with the first)?unsorted unsorted unsortedarray1]CODE]....

View 9 Replies

Compare Version Between Host And Client Download The File If Compare Version Not Same In .net?

May 20, 2011

they need to make some compare version between host version and client version.. and each 1 version different will download the file to the client..[URL]..with both example, how can i make a program in VB.NET just like i said just now?

View 15 Replies

Class With Dynamic Arrays Inside Another Class Which Also Has Dynamic Arrays?

Nov 15, 2011

Below you will find a code sample that I have dummied up to try and demonstrate the issue I am having. However, this is just a dummied up piece of code. The actual program has noting to do with STUDENTS or TEACHERS. Basically, the problem I'm having is trying to have a CLASS within another CLASS each of which contain ARRAYS that need to be dynamic in size. The sample has a CLASS called STUDENTS that can have in theory many students, the number of which are unknown to the CLASS. I need to be able to add STUDENTS to the ARRAY programmatically.

The CLASSROOM Class should also be an Array since each TEACHER will have MANY Students. There will be only 1 Teacher for a given classroom but the SCHOOL will have MANY CLASSROOMS. Again, I need to programmatically add Teachers and Students without having predefined Array sizes. The code I have listed below will NOT work but it demonstrates what I am trying to achieve. I want to be able to reference the CLASS by using something like this ...

School(iTeacherIndex).Student(iStudentIndex) = "Rick Smith"

I feel like I should be able to use ARRAYLIST in both classes but haven't been able to get it to work. I've tried DIM'ing as ARRAY and can't get that to work either.If I can get ARRAYLIST to work then I shouldn't need to worry about expanding the array via UBOUND (if it's even possible).The REAL question is "How do I have a CLASS within a CLASS, each of which has ARRAYS that need to be dynamic in nature so they can be expanded as needed? The size of the array cannot be determined ahead of time".

REMEMBER . . . the actual program has nothing to do with Students and Teachers. This was just my way of demonstrating the issue using an analogy that I thought everyone could understand. The actual Class is much more involved.I have purposely hardcoded some values just to make the sample easier to work with. This is NOT how I normally program but is just here to hopefully make things a little more clear.

Here is the sample code . . .
'***********************************************************************************
'***********************************************************************************
'***********************************************************************************

'Here is the code that is in the form - This obviously doesn't work

Private Sub TeacherTestDemo()
Dim iTeacherIndex As Byte
Dim iStudentIndex As Byte

[code]....

View 2 Replies

In VB Compare Lbl.txt And Lbl.name

Apr 7, 2011

i need to make sure a labels.text and a labels2.name are equal. figured it was straight forward i renamed the label the same name as the label im comparing it too but it comes up false.

View 1 Replies

Asp.net - How To Compare Two Dates

Oct 7, 2011

We would like to compare a date from the db with current date. Here is what I have tried so far: 'Obtain current date Dim curdate As String = Now.ToString("yyyy") 'Now compare curdate with date from db called eventdate. Event date is of dateTime datatype. If drv("eventdate").ToString = "" And Year(drv("eventdate").ToString) = curdate Then

[Code]...

View 3 Replies

Compare 1 Date With Other One?

Jul 28, 2009

I have 2 date ranges with 2 text box, based on that m populating reports.

I want to do in such a way if fromdate and todate <27/06/2009 then it should call come other SP otherwise diff one

[Code]....

View 6 Replies

Compare A Picture With Another?

Jun 19, 2010

Okay what i what to do is to compare one picture to another continuously untill it finds a change and then launches my code. Picture 1 - A picture i put to the form Picture 2 - I wont this to take a picture in a certain area and compare it to the first picture. lets say the first screen shot it took didn't match 'Picture 1' then it will keep taking pictures until it finds something different and when it finds something different it will launch my code.

I dont know if this is the right way to go since i heard something about pixel scanning but that's to hard since you have to find the exact RGB of that pixel. Also theirs like billions on the screen so it would be hard to find a change of color on the screen and then launch a code after that and keep repeating.

View 17 Replies

Compare A Value Greater Or Less Than?

Sep 1, 2011

I am working on my program as I have created picturebox1 and splitter1 in my program. I am coding on the if statement as I am trying to compare on the value that if they are less than 184, then do something.

Private Sub PictureBox1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PictureBox1.Click
If Splitter1.Location <= New System.Drawing.Point(184, 0) Then

[Code]....

I know that I can't compare the value using with <= which I will only have to use = instead of <=, but i still want to compare with the value that if it less than 184, then do something.

View 5 Replies

Compare All Files With MD5?

Oct 21, 2011

I just put 2 datagridview in form1 and both datagridview got filename and MD5 hash. but some data in datagridview1 and datagridview2 got different MD5 hash but same filename.. but how can i compare both MD5 hash and put it into another datagridview (datagridview3)

View 5 Replies

Compare Datetime Between Sql And Vb

Mar 2, 2012

[Code]in my program, i've created a function wherein i will get the min timeentry for type 0 and it depends on the current date. so heres how it goes [Code] what should i put as the value of time entry? i tried format(var,"m") but no success. in the code i post above it also does not work. i get this error "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value." how can i match the value in the database and the current date so that i can retrieve a value?

View 2 Replies

Compare Images And Tell Me If They Are Same?

Dec 3, 2011

I have a source image and another image. I am wanting to compare the two images and tell me if they are the same.

View 3 Replies

Compare Information From Xml?

May 17, 2010

I'm trying to compare values from a single xml file. Here is my xml file set up

<?xml version="1.0" encoding="utf-8"?>
<Updater>
<version>
<corever>0.12</corever>
<soundver>2.21</soundver>
<gfxver>.0.31</gfxver>

[Code]...

What is not working is CompareVersion Sub. Not sure if its even possible, I looked through google and couldn't find anything.

View 2 Replies

Compare Numbers In VB?

Mar 26, 2012

I NEED TO COMPARE 6 NUMBERS from 6 TEXTBOXES with 35 random generated numbers here is what i got:

Dim N(5) As Integer
N(0) = Val(TextBox1.Text)
N(1) = Val(TextBox2.Text)

[code].....

View 19 Replies

Compare One Sentence To Three Others

Oct 19, 2009

I am experienced with Visual Basic, and currently working on a project using VB 2008. I am struggling to come up with a code that compares one sentence to three other sentences. For the input could be a simple textbox and the output being the most probable sentence (and the probability if possible).

View 6 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved