salve non riesco a popolare una dropdownlist ecco il codice :


Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

Dim ddl_1 As System.Web.UI.WebControls.DropDownList

Dim sqlcon As New SqlConnection
Try

Dim cmd As New SqlCommand
sqlcon.ConnectionString = "Data Source=.\SQLEXPRESS; AttachDbFilename='C:\Users\ospite\Documents\Visual Studio 2010\Projects\Applicazione\WebApplication2\App_Dat a\ASPNETDB.MDF';Integrated Security=True;Connect Timeout=30;User Instance=True"
sqlcon.Open()
cmd.CommandText = "SELECT * FROM Camera"
cmd.Connection = sqlcon
Dim rs As SqlDataReader = cmd.ExecuteReader()

Do While rs.Read()

ddl_1.DataSource = rs
ddl_1.DataTextField = "valori"
ddl_1.DataValueField = "idvalori"
ddl_1.DataBind()
Validate()

Loop

Catch
Finally
sqlcon.Close()
End Try

End Sub