Este drop....se llama "obs_1", ahora lo tengo conectado a una tbl de bd Oracle...la cuestion es que cuendo ingreso a la pagina, me carga los datos me muestra lo que hay en la tabla...pero cuando selecciono una opcion de la bd, el drop....no me la selecciona....aca el codigo......favor...
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data" %>
<%@ Page Language="vb" Debug="true"%>
<html>
<head>
<title>Prueba</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script runat="server">
Sub Page_Load(obj as object, e as eventargs)
if ispostback() then
'Dim itemValue As String = obs_1.SelectedItem.Value
Dim objConn As New OleDbConnection (ConfigurationSettings.appSettings("ConnectionStri ng"))
Dim sSQL as string
sSQL = "select DSC_RCH from cod_rch order by cod_rch "
Dim objCmd As New OleDbCommand (sSQL, objConn)
'// open connection
objConn.open
Dim Reader as OleDbDataReader
Reader=objCmd.ExecuteReader()
'// read in and binddata
obs_1.DataSource = Reader
obs_1.DataTextField = "DSC_RCH"
obs_1.DataValueField = "DSC_RCH"
obs_1.DataBind()
' // close conn and the datareader
objConn.Close()
Reader.Close()
'// insert some text to display
obs_1.Items.Insert(0,"<---seleccione--->")
end if
End Sub
sub click(obj as object, e as eventargs)
'Dim itemValue As String = obs_1.SelectedItem.Value
lbl_uno.text= "Usted selecciono:" + obs_1.SelectedItem.Text
end sub
</script>
</head>
<body>
<form id="uno" runat="server">
<asp:dropdownlist id="obs_1" runat="server" ROWS="1" DATAVALUEFIELD="obs_1" DATATEXTFIELD="obs_1" SelectionMode="Single" EnableViewState="true"></asp:dropdownlist><br>
<asp:button ID="dos" Text="Listo" OnClick="click" runat="server"/>
<asp:label ID="lbl_uno" runat="server"/>
</form>
</body>
</html>
Gracias
