Your SQL statement has an error... search_part_no.Text should not be enclosed within quotes. Currently, it is being treated as a string and appended as is to your SQL statement. Hence the error message.
On Jan 19, 9:27 am, Helvin <[email protected]> wrote: > opps. i missed an s. But still, parameters is not a member of > DataAdapters... > > myDA.Parameters.AddWithValue("@part_no", search_part_no.Text)
