well I hope this helps someone out, I figured out the problem. After rewriting my query and testing the dataset, I determined the problem to be with the query itself.
instead of SELECT M.MANUFACTURERID ASMANID, M.MANUFACTURER_NAME AS MANNAME, MV.MANUFACTURERVENDORID AS MAN VENID,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 I used first changed the value to a int instead of a string Dim zvalue As Integer = Me.ddlManufacturer.SelectedValue and then my query was changed to the following: 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 MV.MANUFACTURERID='" & zvalue & "'ORDER BY VENDOR_NAME KP On May 13, 9:36 am, KP <[email protected]> wrote: > 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
