1,105,633 Community Members

arrays and data structures for order

Member Avatar
burnweb
Newbie Poster
3 posts since May 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi,
Im trying to make an order for an invoice that will take in some details like name, number and have an array of product details like price, qty. It uses variables used in class mods. See if you can make sense of this.

Sub webservicetest()

    Dim NewOrder As New struct_XOrder
    Dim LineItems(1 To 2) As New struct_LineItem

    NewOrder.ClientShortName = "DemoClient"
    NewOrder.OrderNumber = "12345"

    LineItems(1).Qty = 5
    LineItems(1).ItemComment = "comment1"
    'LineItems(2).Qty = 10
    'LineItems(2).ItemComment = "comment2"

    Debug.Print NewOrder.ClientShortName
    Debug.Print NewOrder.OrderNumber
    'Debug.Print NewOrder.LineItems(1)


    '''''''''''' Sample C# code - trying to replicate
    NewOrder.LineItems = new LineItem[2]; // initialize to correct number of line items
    LineItem XLine;
    XLine = new LineItem();    // create a new line item
    XLine.ClientShortName = "abcde";         // populate it
    XLine.Qty = 5;
    NewOrder.LineItems[0] = XLine;      // place it to the array
    XLine = new LineItem();             // and so on
    XLine.Qty = 10;
    Xline.ClientShortName = "test";
    NewOrder.LineItems[1] = XLine;
    ''''''''''''''


End Sub
Member Avatar
tinstaafl
Postaholic
2,012 posts since Jun 2010
Reputation Points: 559 [?]
Q&As Helped to Solve: 402 [?]
Skill Endorsements: 35 [?]
 
0
 

First off are you in the right forum? Your code looks like VB.net not VB6. Secondly, if this is VB.net then, I'd use nested classes and lists instead of arrays. List work much the same with one important aspect, they are more dynamic and support growing and shrinking as items are added or removed.

Member Avatar
burnweb
Newbie Poster
3 posts since May 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Its actually vba. Im not sure if this should be in vb6 or vb.net. Im trying to recreate that bit of c# code but im not having much luck.

Member Avatar
tinstaafl
Postaholic
2,012 posts since Jun 2010
Reputation Points: 559 [?]
Q&As Helped to Solve: 402 [?]
Skill Endorsements: 35 [?]
 
0
 

If it's vba this is the right place. But you're facing an uphill battle here. C# is accessing the worksheet in a different manner than you will. Basically you want to design the form in excel first then access the parts of the form using the Worksheet object.

Unless you specifically need features of excel, that are hard to duplicate, you might be better off using a series of forms in .net.

Member Avatar
burnweb
Newbie Poster
3 posts since May 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Ok thanks for the advice.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: