ASP.NET - Update Dataset directly to DB
- by karthik
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
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)
I am using Data Application Block 4.1? It will work there right?
If anyone can give example for update will be great ( with Procedures).
Thanks
Ka
