SQL Where clause Filter Help

The main trick is to build the SQL as a string and put single quotes around the variables that the user will select. if you are filtering on all 3 fields you would use the query below. However depending on the functionality you might want to build it so they can filter on any or none (to get all rows)

A couple notes on the code below, the " + lets you code to the next line for easy reading. Just make sure you leave a space before the " of the two lines will run together, and in the where note the single quotes next to the double quotes

String MySQL  = "Select ColorID, ColorType, ColorNotes, ColorStatus " +
  "From ColorTable "+
  "Where Colortype = '" + Selectedtype + "' " +
  "AND colorStatus = '" + SelectedStatus + "' " +
  "AND colorLocation = '" + SelectedLocation + "' "; 

This will result in a string that will look like this:

Select ColorID, ColorType, ColorNotes, ColorStatus From ColorTable Where Colortype = 'Selectedtype' AND colorStatus = 'SelectedStatus' AND colorLocation = 'SelectedLocation'