Data displaying question

[Bruce Groen]

I need some help on the best way to do this. I am writing an application in
vb.net and asp.net. It is using a SQL 2000 database. I have a list of
objects in a table that looks something like this:

ID ObjectName PropName PropName2 PropName3
1 Object 1 Property1 Property2 Property3

Then I have a fairly basic user table with a userid for each user. The
users login and request objects. When they request an object, I add a
record to another table with the ID # of the object, the ID # of the user
and the time and date they requested it. Now the administrative people need
to login and assign the object to one of the people that requested it. I
can't figure out how to display the data and take the user input. I have
been using a data grid for most everything else with an edit button that
opens another window with a screen to edit the record. What I would like to
do is display all the objects in a grid an then have a drop down list on
each record that shows all of the people that requested the object and let
the user select the one user that gets it. But I can't figure out how to do
this that isn't very database intensive. There are a couple hundred objects
and about a hundred users. Thanks for nay help you can offer.

[Patrick.O.Ige]

Bruce try looking theough this at:
http://aspnet.4guysfromrolla.com/articles/032203-1.aspx
It should guide you.
Patrick
"Bruce Groen" <br****@integrilogic.com> wrote in message
news:u3**************@TK2MSFTNGP12.phx.gbl...

I need some help on the best way to do this. I am writing an application in vb.net and asp.net. It is using a SQL 2000 database. I have a list of
objects in a table that looks something like this:

ID ObjectName PropName PropName2 PropName3
1 Object 1 Property1 Property2 Property3

Then I have a fairly basic user table with a userid for each user. The
users login and request objects. When they request an object, I add a
record to another table with the ID # of the object, the ID # of the user
and the time and date they requested it. Now the administrative people need to login and assign the object to one of the people that requested it. I
can't figure out how to display the data and take the user input. I have
been using a data grid for most everything else with an edit button that
opens another window with a screen to edit the record. What I would like to do is display all the objects in a grid an then have a drop down list on
each record that shows all of the people that requested the object and let
the user select the one user that gets it. But I can't figure out how to do this that isn't very database intensive. There are a couple hundred objects and about a hundred users. Thanks for nay help you can offer.