How to bind DropDownList with SQL server in asp.net

Question

Hi How to bind DropDownList with SQL server in asp.net ?

Satyapriya Nayak · Answer

Hi Nikos If this post helps you mark it as answer Thanks

Satyapriya Nayak · Answer

Hi Nikos Here is your desired code and run the attachments. Imports System.Data Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item(ConnectionString).ToString() Dim sqlda As SqlDataAdapter Dim com As SqlCommand Dim ds As DataSet Dim dt As DataTable Dim str As String Dim con As New SqlConnection(strConnString) Protected Sub Page_Load(ByVal sender As Object ByVal e As System.EventArgs) Handles Me.Load DropDownList1.Items.Add(Select any country) If Not Page.IsPostBack Then con.Open() str = select * from country com = New SqlCommand(str con) Dim reader As SqlDataReader = com.ExecuteReader While reader.Read DropDownList1.Items.Add(reader(countryname)) End While reader.Close() con.Close() End If End Sub End Class Thanks If this post helps you mark it as answer