T
Ted
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.
Thanks,
Ted
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.
Thanks,
Ted