Member Avatar for priyala

Hi,
I have doubt if I need to do a select statement with Where clause and the value to the varclause comes from the text box in the form.

Then what is the syntax of the SQL select statement in VB.
Thanks,
Priya

  • 2 Contributors
  • 1 Reply
  • 66 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Mbt925
Member Avatar for Mbt925 
SELECT [B]*[/B] FROM [B]Table1[/B] WHERE [B]Code[/B]='" & [B]Text1.Text[/B] & "'"
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.