visual studio 2010 get connection in SelectedIndexChanged using Oracle in Gridview

wisadd

New Member
In my Gridview, I read from an Oracle tableAA. That works OK.When I select one of the rows, I need to run a query based on the row chosen. ie....Select Phone from tableBB where emp_id= gvDetails.SelectedDataKey.ValueThis works in "View in Browser". In actual web, I get errorBC30002: Type 'OracleConnection' is not defined.based on this line:Dim objConn As Object = New OracleConnection(oradb)If I comment the section about tableBB out the page works in the actual web.How can I create another connection or be able to use the same connectionon the Gridview in the SelectedIndexChanged section?TIASteve42
 
Back
Top