用两个dropdownlist实现主次选择

最新推荐文章于 2016-04-25 15:07:00 发布

原创最新推荐文章于 2016-04-25 15:07:00 发布 · 931 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#cmd #database #webform #server #class

我的asp.net 专栏收录该内容

31 篇文章

订阅专栏

本文介绍了一个使用ASP.NET实现的级联DropDownList控件的例子。通过两个下拉列表，第一个选择省份，第二个根据所选省份显示对应的城市。利用SqlConnection连接数据库，SqlCommand执行SQL查询并填充下拉列表。

比如第1个选为省分，第2 个为相对的市，

如图：

代码：

Imports System.Data
Imports System.Data.SqlClient
Public Class WebForm1
Inherits System.Web.UI.Page

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        If Not IsPostBack Then
            Dim con As SqlConnection
            Dim cmd As SqlCommand
            Dim dr As SqlDataReader
            con = New SqlConnection("server=(local);uid=sa;pwd=;database=lab")
            cmd = New SqlCommand("select * from test1", con)
            con.Open()
            dr = cmd.ExecuteReader
            DropDownList1.DataSource = dr
            DropDownList1.DataTextField = "proName"
            DropDownList1.DataValueField = "proID"
            DropDownList1.DataBind()
            dr.Close()

con.Close()

End If

End Sub

    Private Sub DropDownList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
        Dim cmd2 As SqlCommand
        Dim dr2 As SqlDataReader
        Dim con2 As SqlConnection
        con2 = New SqlConnection("server=(local);uid=sa;pwd=;database=lab")
        cmd2 = New SqlCommand("select * from test2 where proID=" + DropDownList1.SelectedValue, con2)
        con2.Open()
        dr2 = cmd2.ExecuteReader
        DropDownList2.DataSource = dr2
        DropDownList2.DataTextField = "cityname"
        DropDownList2.DataValueField = "cityID"
        DropDownList2.DataBind()
        dr2.Close()
        con2.Close()
    End Sub
End Class