How should I handle code table lookups?

  • Thread starter Thread starter AnAnimal
  • Start date Start date
A

AnAnimal

We are moving a rather large application to the VB.NET platform.
This application has a ton of table lookups.
ie. code & description or code, category & description or code, class,
category & description

Most of the users know the more common codes and will just enter them
but occasionally will need to look these codes up (especially when a
temp is using the system!!).

How would the VB.NET veterans handle this?
Which control(s) would you use?
 
If they are refereneced a lot, I'd load them into datatables stored in a
Module or a class that has them as Stored properties. Since lookups don't
change a lot, you don't have to worry about the data getting stale. If it
does change a lot, periodically refresh the tables. You can bind Grids,
Comboboxes and everything else to these tables and if you store them in a
module, you'll greatly minimize trips to the DB.

Hopefully this helps, but if not, let me know.

Cheers,

Bill
 
Thanks Bill!

but I was actually looking for the GUI.
The actual form control(s) that would show all the information to the
user that will aid them with the lookup process.
 
Hello,

AnAnimal said:
We are moving a rather large application to the
VB.NET platform.
This application has a ton of table lookups.
ie. code & description or code, category &
description or code, class, category & description

Most of the users know the more common codes and
will just enter them but occasionally will need to look
these codes up (especially when a temp is using the system!!).
Click to expand...

If you are referring to a database solution:

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:

news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet

Web interface:

http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet
 
No I am not looking for a database solution.

I am looking for a form control or group of form controls that VB.NET
veterans would use to accomplish a table lookup.

Our solution would have been a multi-column combobox. But this control
does not exist in native VB.NET. We have a working solution by using a
fixed pitch font and spacing out the dropdown information to look like
columns.

I was hoping for a few other ideas of how to display this information
to the user.
 
Hello,

AnAnimal said:
I was hoping for a few other ideas of how to display this information
to the user.
Click to expand...

Sorry, I misunderstood your question.
 
Back
Top