Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Controls > Simplifying item selection problem

Thread Tools

Simplifying item selection problem

Posts: n/a
In this problem, I could use a brain dead, brute force, solution and
just populate a dropdownlist from a lookup table. This is anything but
user friendly, though, since the lookup table has almost 10,000 items.

What I want to do is create a search form and use the item selected in
that form to populate a cell on a data entry grid on the main form.
The search form would contain an edit box into which the user sets a
value, and a list box that is populated using the obvious SQL SELECT
statement with a WHERE clause using the LIKE keyword. In other words,
using a food analogy, the string entered (bean) would, when passed as
the parameter value for the SELECT statement, return a list of items
such as "Beans, baked", "Beans, green, frozen", "Beans, green, fresh",
"Beans, yellow, frozen", "Beans, kidney, canned", "Beans, black,
canned", &c.

The question is, in an ASP.NET2 or ASP.NET3 form, how would I get the
value selected in the list box on the search form into a cell on the
grid on the first form? This gets a little complicated in that the
third column needs to be populated using a dropdownlist that is
populated using two parameters: the value in the first column and the
value in a user preference dropdownlist. I haven't completely figured
this out either, but one thing at a time.

Is there a simpler way to do this? The requirement, again using the
food analogy, is to allow the user to select foods to be added to the
grid with the constraint that only those foods in the lookup table are
permitted, and to protect the user from typos. The secondary
requirement is that the last column represents units of measurement, so
if the food is measured by volume, only volume units are present in the
dropdownlist, while if it is measured by weight, only weight units are
present, and if the user has selected metric units only metric units
are available while if he has selected imperial units, only imperial
units are available for selection.



Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
simplifying c code with function pointers C Programming 8 05-22-2006 12:45 AM
Simplifying this combinational logic? Shawn VHDL 2 02-27-2006 04:24 AM
Simplifying HTML code Robert HTML 7 02-01-2006 08:07 AM
Simplifying imports? Python 9 09-13-2005 11:39 PM
simplifying use of properties kartik Java 23 11-10-2004 08:57 AM