Good Morning All,
I am using vb.net to filter a drow down list on a web form. To give
you a little background on the process I am working on a inventory
tracking system. On this part I`m adding a new device to my inventory
system. When a select a manufacturer the vendor DDL should be
populated dynamically off the selection. Here lies the problem if I
have more than one manufacturer to choose from, the drop down list
automatically reverts back to the first selection in the list. I have
included a snippet of my code. Please advise. thanks
'set dropdownlistcontrol to visible on postback
Me.ddlVendor.Visible = True
Dim zvalue As String = Me.ddlManufacturer.SelectedItem.Text
Dim dt As DataTable
'populate vendor dropdownlist
dt = USA.Data.DataLayer.ExecuteSQL("SELECT M.MANUFACTURERID AS
MANID, M.MANUFACTURER_NAME AS MANNAME, MV.MANUFACTURERVENDORID AS
MANVENID,V.VENDORID AS VENID,V.VENDOR_NAME AS VENNAME FROM
TBL_MANUFACTURER AS M INNER JOIN TBLMANUFACTURER_VENDOR AS MV ON
M.MANUFACTURERID = MV.MANUFACTURERID INNER JOIN TBLVENDOR AS V ON
V.VENDORID=MV.VENDORID WHERE V.VENDOR_NAME='" + zvalue + "' ORDER BY
VENDOR_NAME")
If dt.Rows.Count > 0 Then
'Clear out any previously added items
Me.ddlVendor.Items.Clear()
'Add first list item
Me.ddlVendor.Items.Add("Select a Vendor")
'Add Vendors from Database
Me.ddlVendor.DataSource = dt
Me.ddlVendor.DataTextField = "VenName"
Me.ddlVendor.DataValueField = "ManID"
'make sure data is appended and not overwritten
Me.ddlVendor.AppendDataBoundItems = True
Me.ddlVendor.DataBind()
End If
