Hi.
I did not post this in database forum because the data will run on an asp.net site.
I have 3 solution in my mind and i would like some opinions.
What i want to do is create a parent-child relationship on 2 controls.
A listbox and a textbox.
I will populate the listbox with data(this is taken care of so ignore) and what i want to do is when i click on an item in the listbox then the textbox to show it's joined related item(one item only).
This is not a problem in windows forms app but in asp, since i'm new i don't know what would be better for a faster retrieval on the page.
So the 3 options i have in mind are:
1)DAL.The standard create a query and let one @parameter wait for the id.
2)ADO.NET with possibly an sqldatasource.In standard forms i would have chosen simple ado.net but in asp?So either constantly open,close the db and retrieve the item or use an sqldatasource and chance the parameter.
3)Asynchronous handler page.Bind the textbox to an asynchronous page that contains the connection and expect the @id parameter.

I admit that i'm not fond of DAL but if it will boost speed then i will use it.But i have a though that says that simple ADO will be faster.

Thanks for any comments made