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? 5 4952
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
"AnAnimal" <An******@somew here.net> wrote in message
news:bb******** *************** *********@4ax.c om... 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?
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.
On Thu, 11 Sep 2003 12:05:14 -0400, "William Ryan"
<do********@com cast.nospam.net > wrote: 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 "AnAnimal" <An******@somew here.net> wrote in message news:bb******* *************** **********@4ax. com... 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?
Hello,
"AnAnimal" <An******@somew here.net> schrieb: 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!!).
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/microsof...amework.adonet
Web interface: http://msdn.microsoft.com/newsgroups...amework.adonet
--
Herfried K. Wagner
MVP · VB Classic, VB.NET http://www.mvps.org/dotnet
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.
On Thu, 11 Sep 2003 18:28:58 +0200, "Herfried K. Wagner [MVP]"
<hi*******@m.ac tivevb.de> wrote: Hello,
"AnAnimal" <An******@somew here.net> schrieb: 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!!).
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/microsof...amework.adonet
Web interface:
http://msdn.microsoft.com/newsgroups...amework.adonet
Hello,
"AnAnimal" <An******@somew here.net> schrieb: I was hoping for a few other ideas of how to display this information to the user.
Sorry, I misunderstood your question.
--
Herfried K. Wagner
MVP · VB Classic, VB.NET http://www.mvps.org/dotnet This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Mudd |
last post by:
I must be missing something here. It's clearly faster to lookup an item
directly in a dictionary than to scan through a list. So when I have a
large lookup table I always load it in the form of a dictionary. But it
seems a waste. I end up having to assign an artificial value to the
dictionary entry. Below I assign the value "None" to each dictionary
entry.
Is there a better way? I feel like I'm misusing the dictionary.
|
by: Rob Mazur |
last post by:
Hi. I'm trying to create a query that pulls information
from 3 seperate tables. Here's how I want it to work:
User is prompted for SSN
Table 1:
SSN
Name
Gender
|
by: Steve Jorgensen |
last post by:
Hi folks,
I'm posting this message because it's an issue I come up against relatively
often, but I can't find any writings on the subject, and I haven't been able
to figure out even what key words one would use to look for it.
First, in broad philosophical terms, code actually -is- data. Code is the
data that's fed into a compiler, interpreter, or microprocessor that tells it
what to do. Code execution is, then, just a form another...
|
by: Colin |
last post by:
Question#1:
Many of my forms have combo boxes (e.g. CustomerID). The combo box
looks up CustomerName from CustomerID in the Customer table. Am I
better off including CustomerName in my query (which the form depends
on)and have the combo box based on CustomerName or is it better to
limit the query fields by using just CustomerID? I'm guessing that
keeping queries to a minimum will impact the speed in which queries
take place.
Questions#2
|
by: Gigi.com |
last post by:
Hi All.
I need some help trying to pull prices from a price matrix. Here's an
example:
>>>> 1000 1500 2000 2500
-----------------------------------------
1000 ¦ 10.20 11.95 12.55 13.76
1500 ¦ 11.23 12.23 13.45 14.45
| |
by: Paul |
last post by:
Hi,
When should I use a list (in table properties: like
Ford;Mercedes;BMW;Audi )
and when should I use a lookup table??
And second question: IF I use a lookup table, should I always make a
relation (1-to-many) in my relation scheme?
Any help is greatly appreciated, I'm a bit puzzled.
|
by: gerry |
last post by:
I want to populating an asp list box from a simple access lookup list
(single column not a table.)I don't want to create tables just for
lookups as the values will be descriptive only and will never change.
What would be the command to rerieve these single column lookups in
ASP script?
Or do I have to create access tables just to hold these static lookup
values?
|
by: agarwasa2008 |
last post by:
Hi,
I have a linked table called tbltest and some bounded forms (which
add, update, delete records) that were created using that linked
table. For some necessary reasons I had to create another linked table
called tblComponents and then I bounded the original forms to this new
table. I did change the
control source: Description (Field name)
RowSource Type: Table/Query (which remains the same)
|
by: raylopez99 |
last post by:
A quick sanity check, and I think I am correct, but just to make
sure: if you have a bunch of objects that are very much like one
another you can uniquely track them simply by using an ArrayList or
Array, correct? An example: create the object, create an array, the
stuff the object into the array. Later on, assume the object is
mutable, the object changes, but you can find it, if you have enough
state information to uniquely identify...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |