Member Avatar for ShishiLearn

Hello guys, I just want to ask for some help with my program
I'm a beginner and new here
This my code : Under ButtonAdd

    Dim adapter 2 as New SqlDataAdapter (SELECT 'AddOnNo', 'AddOnName'  , 'Price' FROM Table1 WHERE AddOnNo = " & ComboBox1.SelectedValue,con) 



    adapter2. Fill(table)

    txtAddOnName.text = table (0)(1)
    txtAddOnPrice.text = table (0)(2)


End sub
Edited by Reverend Jim because: Corrected code formatting
  • 2 Contributors
  • 1 Reply
  • 49 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

Try putting a double quote before SELECT.

commented: Hello. Thank you for your help reverend Jim. I appreciate you and God bless ! +0
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.