jzfla
02-09-2007, 07:29 PM
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.
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.