在列表视图中设置下拉列表的selectedvalue [英] set selectedvalue of dropdownlist in listview

问题描述

我后面有以下代码.我正在尝试在列表视图的编辑模板中设置下拉列表的selectedvalue.但我在

I have the below code behind. I am trying to set the selectedvalue of a dropdownlist inside a edit template of a listview. But I get a null reference error at

ddlWorkArea.DataSource = ds

处收到空引用错误

Private Sub ListView1_ItemEditing(sender As Object, e As System.Web.UI.WebControls.ListViewEditEventArgs) Handles ListView1.ItemEditing

    Dim i As Integer = e.NewEditIndex
    Dim strWorkArea As String
    Dim lstWorkArea As ListItem
    Dim txtWorkArea As Label = ListView1.Items(i).FindControl("WorkAreaLabel")
    Dim ddlWorkArea As DropDownList = ListView1.Items(i).FindControl("WorkAreaDDL")
    Dim Site As String
    Site = Me.TextBoxAuditSite.Text

    Dim strConn As String = ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString
    Dim objConn As New SqlConnection(strConn)
    Dim ds As New DataSet()
    Dim myda As New SqlDataAdapter("SELECT [WorkArea] FROM [zEdits]", objConn)
    myda.Fill(ds, "workArea")
    ddlWorkArea.DataSource = ds
    ddlWorkArea.DataValueField = "WorkArea"
    ddlWorkArea.DataBind()
    If txtWorkArea IsNot Nothing Then
        strWorkArea = txtWorkArea.Text
        lstWorkArea = ddlWorkArea.Items.FindByText(strWorkArea)
        If IsNothing(lstWorkArea) Then
            ddlWorkArea.Items.Insert(0, "")
        Else
            ddlWorkArea.Items.Insert(0, "")
            ddlWorkArea.SelectedValue = strWorkArea
        End If
    End If


End Sub

推荐答案

myda.Fill(ds, "workArea")应该应该是myda.Fill(ds, "zEdits").

这篇关于在列表视图中设置下拉列表的selectedvalue的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！