Data Tier Application Development with VB.NET Part 2 - Using parameterized queries Page 2.
by Steve Ochani http://www.steveo.us
You will now have to modify your table adapter. So open your dataset from the Solution Explorer and right click the table adapter then select Add Query.
On the Choose a Command Type screen make sure Use SQL statements is selected and click Next.
On the Choose a Query Type screen make sure SELECT which returns rows is selected.