DropDownList触发

     Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim Conn As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)
        Conn.Open()
        Dim Da As SqlDataAdapter
        Dim Rs2 As DataSet
        Dim Dt As DataTable
        Da = New SqlDataAdapter("select * from blog_reg where blog_user='" & DropDownList1.SelectedValue & "'", Conn)
        Rs2 = New DataSet()
        Da.Fill(Rs2, "list2")
        Dt = Rs2.Tables("list2")
        GridView1.DataSource = Rs2.Tables("list2").DefaultView
        GridView1.DataBind()
        blog_user.Text = Dt.Rows(0).Item("blog_user").ToString
        blog_nc.Text = Dt.Rows(0).Item("blog_nc").ToString
        blog_pwd.Text = Dt.Rows(0).Item("blog_pass").ToString
        blog_name.Text = Dt.Rows(0).Item("blog_name").ToString
        blog_city.Text = Dt.Rows(0).Item("city1").ToString
        regtime.Text = Dt.Rows(0).Item("reg_time").ToString
        Rs2 = Nothing
    End Sub

 

        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" AppendDataBoundItems="True" >
        </asp:DropDownList>