Design Question, VB6 to VBExpress

Hot Topic

Problem with SQL query
my app is invisible?
Good and Free Tutorials
Registration Benefits
How is cl.exe provided? Where should one get it from?
Function help
Can't remove Microsoft SQL Server Configuration Manager from my system.
NEWBIE BEGINNER
Visual C# Express with CE
ListView Control

VS Express Editions

Running an exe included in the project
ListView Woes
Where are the registration benefits
Append to XML file
Express Edition promotion period...
ButtonArray
Retrieve data from Excel and store it in Access through VB
Importing vb6 files the C#
GetPixel Colour Value
Tab pages- enabling and disabling (or mimicing as seen in C# thread)

Design Question, VB6 to VBExpress

Hi..I am moving from VB6 to VBExpress (with a very short .NET 2002 stop) and have a design question.

Suppose I have two string arrays. The first has 20 elements and gives the make of cars (e.g. GM, Ford, Rover, etc). The second string array has 15 elements and contains the names of various individuals. My goal is to match each infividual with a car make. There will be only one matching car make for each individual.

My VB6 solution is to have two datagrids on a form. The car make datagrid contains simply the list of car makes in a single column. The second datagrid contains the array of individual names in the first column and a column of textboxes in the second column. For each individual, the user enters the row number in the car make array corresponding to the individual's car make. (It would seem that I don't need a datagrid for the car make array. However, it's needed for other parts of the solution that aren't relevant to this particular problem).

One can imagine that it would be awkward for users to type in the appropriate car make row numbers when there are even more car makes and individuals. Any advice on an easier way to solve this problem will be greatly appreciated. My objective is a user-friendly way to match car makes to individuals.

Thanks.

 

 

 

Answer this question

Design Question, VB6 to VBExpress

  • Remerono

    Well... perhaps I didn't explain the problem clearly. I used the auto example to, I thought, make it simpler. In reality I have a string array of resources (their names) and the amounts used. The other string array, read from a different file, contains prices. The user's job is to associate a price with each resource, hopefully in the most efficient way. Maybe I could have two list boxes, and have them simply drag a resource onto the appropriate price. That would certainly be easier than manually entering the row number of the resource in a price textbox. Any other thoughts Thanks again. Lance

  • wmleonar

    ReneeC wrote:

    Perhaps I don't understand the question but why no use listboxes

    One listbox for car makes and one for people's names

    I second that motion.

  • No-spam Sam

    Basically, if you only have two single columns then the ListBox would be the way to go. If you have multiple columns that still don't require editing I'd be inclined to go with a ListView rather than a DataGrid anyway. Either way, or even with a DataGrid, if you don't want to implement drag-and-drop you could simply have the user select one item from each list and then press a single button to associate the two.

  • Dabi

    Perhaps I don't understand the question but why no use listboxes

    One listbox for car makes and one for people's names



  • Design Question, VB6 to VBExpress
Answer this question