VB.NET ASP.NET DropDownList Bind To Table Source Code Example

Pluralsight courses
LinkedIn Premium uses PayScale to estimate job salaries

Premium (Not Free) Video Tutorials

Free Video Tutorials & Free Tools

VB.NET ASP.NET DropDownList Bind To Table Source Code

Purpose: – Illustrates using and bind to for VB.NET ASP.NET.

  1. Install Visual Web Developer 2008
  2. Install SQL Server Express
  3. Download Northwind Database
  4. Attach Northwind Database to Databases in Sql Express


  1. Use Visual Web Developer 2008
  2. Select File/new web site; select template ASP.NET website; Select Visual Basic for Language;

    name of website in Location field could be VBNET_ASPNET_Syntax.

  3. Right-click project name in solution explorer; add new folder; name of folder could be Standard_Controls
  4. Right-click folder; add new item; Select Web Form; check place code behind in separate file;

    Web Form Name could be DropDownListBindToTable

  5. Copy first set of code into DropDownListBindToTable.aspx
  6. Copy second set of code into DropDownListBindToTable.aspx.vb
  7. Right-click on DropDownListBindToTable.aspx and select View in Browser

Step 1: Click on XML to Cut-n-paste code into DropDownListBindToTable.aspx

 XML |  copy code |? 
< %@ Page Language="VB" AutoEventWireup="false" CodeFile="DropDownListBindToTable.aspx.vb" 
Inherits="Standard_DropDownListBindToTable" %>
< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <form id="form1" runat="server">
        <asp:dropdownlist ID="DropDownList1" runat="server">

Step 2: Click on VB to Cut-n-paste code into DropDownListBindToTable.aspx.vb
 Visual Basic |  copy code |? 
Imports System
Imports System.Data
Imports System.Data.SqlClient
Partial Class Standard_DropDownListBindToTable
    Inherits System.Web.UI.Page
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim con As SqlConnection = New SqlConnection("Server=(local)\SQLEXPRESS;Initial 
Catalog=Northwind;Integrated Security=SSPI")
        Dim cmd As New SqlCommand()
        cmd.CommandText = "SELECT EmployeeID, FirstName + ' ' + LastName as FullName FROM 
        cmd.Connection = con
        Dim Table1 As DataTable
        Table1 = New DataTable("Employees")
        'creating a table named Employees
        Dim Row1 As DataRow
        'declaring row for the table
        Dim EmployeeID As DataColumn = New DataColumn("EmployeeID")
        'declaring a column named EmployeeID
        EmployeeID.DataType = System.Type.GetType("System.Int32")
        'setting the datatype for the column
        'adding the column to table
        Dim FullName As DataColumn = New DataColumn("FullName")
        FullName.DataType = System.Type.GetType("System.String")
            Dim reader As SqlDataReader = cmd.ExecuteReader '(CommandBehavior.SingleRow)
            While reader.Read()
                Row1 = Table1.NewRow()
                'declaring a new row
                Row1.Item("EmployeeID") = reader.GetInt32(0)
                'filling the row with values. Item property is used to set the field value.
                Row1.Item("FullName") = reader.GetString(1)
                'filling the row with values. adding FullName
            End While
        End Try
        DropDownList1.DataSource = Table1
        Me.DropDownList1.DataTextField = "FullName"
        Me.DropDownList1.DataValueField = "EmployeeID"
    End Sub
End Class

Related posts:

  1. C# Select Statement Source Code Example Source Code example shows how to use Sql Select in...
  2. C#: Sql Stored Procedure Source Code Example C# Sql Stored Procedure source code example with SqlDataReader...
  3. VB.NET Sql Command Update Statement Source Code Example VB.NET Source Code Example shows how to use Sql Command...
  4. SqlDataReader Example – VB.NET – SqlDataReader Example Source code example in VB.NET of SqlDataReader...
  5. SqlDataReader Example – C# – SqlDataReader Example C# Source code example shows how to use SqlDataReader to...

Related posts brought to you by Yet Another Related Posts Plugin.


2 Responses to “VB.NET ASP.NET DropDownList Bind To Table Source Code Example”
  1. mmormann says:

    Excellent Code!

  2. How to fill table in spacific fild for example fullname dropdownlist in select

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Powered by WP Hashcash

This blog uses the cross-linker plugin developed by Web-Developers.Net