Your SQL query does not state the field that you are querying against. Instead of
WHERE =
, you should have
WHERE yourField =
(where yourField should be substituted for the name af the field you wish to query against. You should also consider using parameterised queries instead of string concatenation, so I would write the query like this:-
SELECT field1, field2, field3 FROM myTable WHERE field4 = @field4Parameter;<br />
mycommand.Parameters.AddWithValue("@field4Parameter", myParameter)
Notice i named all my fields in the query instead of using the * symbol. That way when I retrieve the results they always come back in the same order.
Hope that helps