Hola Hell08 y como esta tu?. La verdad lo probe y sigue sin mostrarme nada
Este es codigo completo y la base de datos la describi arriba
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System" %>
<%@ Page language="VB" Codebehind="Prunmil.aspx.cs" AutoEventWireup="false" Inherits="Rainbow.DesktopModules.Agencia.Prunmil" %>
<HTML>
<HEAD>
<script language="VB" runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim ds As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection("SERVER=MDS01; DATABASE=be; INTEGRATED SECURITY=false;PASSWORD=sa;USER=sa")
MyCommand = New SqlDataAdapter ("select EstadoID, Nombre_Estado from Estado" , MyConnection)
ds = New DataSet () ' parte nueva
MyCommand.Fill(ds,"Estado")
DropDownList1.DataSource = ds.Tables("Estado").DefaultView
DropDownList1.DataTextField = "Nombre_Estado"
DropDownList1.DataValueField = "EstadoID"
DropDownList1.DataBind()
end Sub
</script>
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:dropdownlist id="DropDownList1" runat="server" BackColor="AliceBlue" Font-Names="Arial" ForeColor="Black"></asp:dropdownlist>
</form>
</body>
</HTML>