Question Retrieve row values from dropdown having ds as source

[Premy]

Hi there,

I have a dataset ds which retrieves: ProdID, ProdName, ProdPrice From tblProducts.

Since ds is already loaded and needed in multiple locations, I'd like to use it as the datasource for my dropdown ddlProds:

ddlProds.DataSource = ds
ddlProds.DataValueField = "ProdID"
ddlProds.DataTextField = "ProdName"
dddlprods.DataBind()

So far so good, I suppose. Now after I select a given product in the dropdown, how could I retrieve the values (from that row) for ProdID, ProdName and ProdPrice?

Used to be dead easy in VB and Access, but I'm a bit lost here.

Appreciate any help

Regards,
Premy