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

How to bind DropDownList with SQL server in asp.net

Answers (2)