Member Avatar for senthil_aries
senthil_aries 0 Newbie Poster

My requirement is to select a supplier name from a Dropdown list(DropDownList_Supplier) and use the value to get Supplier id from the table "[SQS].[dbo].[Services]". I am using the below code and i am not able to get the value in the required field.

Public SUPTEXT As String = "SELECT [ID] FROM [SQS].[dbo].[Services]"
Dim supplierCriteria As String = SUPTEXT.ToString()
supplierCriteria += " WHERE [Supplier] = '" & DropDownList_Supplier.SelectedValue & "'"
DetailsView1.Rows(1).Cells(1).Text = supplierCriteria.ToString()

Can someone help me on this please?

  • 1 Contributor
  • 0 Replies
  • 49 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.