I have a TableAdapter defined in ASP.NET (Vis Studio 2005) for the Northwind "Products" table.

I have defined a QUERY called GetProductByID.

I am trying to create a page which asks the user for an ProductID and then click SEARCH.

The SEARCH button will attempt to read the record from the SQL TAble to allow for display/update.

My question is how do I do this properly?

I know it has something to do with NorthwindTAbleAdapter.GetPRoductbyID(ProductIDGoesHere)

Also, how do I tell if the record was not found on the table - what is the code to check for that.

If you have sample code I greatly appreciate it!

Thank you.