update database

Posted by Prv299 under ASP.NET on 9/25/2008 | Views : 1278 | Status : [Member] | Replies : 3
i am developing a web application.In that i need to reflect the changes in database when i modify data in dataset. i.e., i want to update back end data from front end using dataset,data adapter.

how can i achieve this one?could any one give the code for this one...


Thank you.




Responses

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

if you need update dataset means use this

ds.Tables[0].Rows[0].BeginEdit();
ds.Tables[0].Rows[0][1] = "Jesus";
ds.Tables[0].Rows[0].EndEdit();



database means
using update query


update tablename set dbfilename=value where fieldname=1



Mark as Answer if its helpful to you

Prv299, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi
Please mark as answer if it helpful to you.


Mark as Answer if its helpful to you

Prv299, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Poster on: 9/25/2008 [Member] Starter

Up
0
Down
Hey,

Just see this article http://www.dotnetfunda.com/articles/article60.aspx and go through the code block carefully, you will see he is updating the record back into the Database using dAd.Update.

Thanks

Prv299, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response