Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
02-09-2007, 07:29 PM #1
- Join Date
- Feb 2007
- Thanked 0 Times in 0 Posts
Question on Table Adapter and Reading One Record
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!