Hi,

Description:

I wanted to update dataset to database in Asp.NET. Instead of retrieving the entire table, I am retrieving only one record

using the following statement :-

 select * from Products where ProductID=3

Now I wanted to update dataset directly in to DB by using following statements (DAP 4.1)

db.UpdateDataSet(ds, ds.Tables[0].TableName, null, cmdupdate, null, UpdateBehavior.Standard);

Questions

1. Can I Retrieve only one row from DB while a lot of other records are there and update back using Adapter update? ( In other words, I am not selecting all records from table)
2. I am using Data Application Block 4.1? It will work there right?
3. If anyone can give example for update will be great ( with Procedures).

Thanks Ka