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


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.
Prerequistes:

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

Instructions:

  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" 
 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:dropdownlist ID="DropDownList1" runat="server">
        </asp:dropdownlist>
    </div>
    </form>
</body>
</html>
 


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 
 
Employees"
        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
        Table1.Columns.Add(EmployeeID)
        'adding the column to table
        Dim FullName As DataColumn = New DataColumn("FullName")
        FullName.DataType = System.Type.GetType("System.String")
        Table1.Columns.Add(FullName)
 
 
 
        Try
            con.Open()
            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
                Table1.Rows.Add(Row1)
 
 
            End While
            reader.Close()
        Finally
            con.Close()
        End Try
        DropDownList1.DataSource = Table1
        Me.DropDownList1.DataTextField = "FullName"
        Me.DropDownList1.DataValueField = "EmployeeID"
        DropDownList1.DataBind()
    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.

Comments

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