Member Avatar for andrewktmeikle

Hey, i am having trouble with a project i have for school. The problem is as follows:

I have one database(access), and it contains the specifications for 3 PC's( will be more but not atm), i have added a column stating the specification of the pc. I have an adodc control to display the data but i dont know how to search and sort the database on the specification field(high, med, low) that the user selected and then display the results.

If somone could suggest code and any method to do this it would be much appreciated

thanks, andrew

  • 3 Contributors
  • 4 Replies
  • 200 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by jireh
Member Avatar for debasisdas

Try to implement the logic by SQL

Member Avatar for andrewktmeikle

Try to implement the logic by SQL

what kind of sql code should i use? i have tried using a query, but so far no success! :(

Member Avatar for debasisdas

can u kindly post your table structures for my reference please.

Member Avatar for jireh

can you please post your coded query here so i can help...

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.