New Members FAQ
Talk to Webmaster Tony John
23 Jul 2006
i am working in windows forms. I have a form in that i put one datagrid. the datagrid was populated with the data in a oracle table thru dataset. Now i want to update the oracle table from the cahnged values in the datagrid. How it possible. wen i try with accept change method the dataset is updating. but not database. so any body please describe me about this detail. and please send me any sample code so that i can understand how it will work.
Date: 23/Jul/2006 Rating:
You need to configure a dataadapter with the updated dataset and just issue an update command.
SqlDataAdapter da = new SqlDataAdapter("select * from tbl1",con);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
Note: The commandbuilder object is used to configure the dataadapter with the insert, update and delete statements and its mandatory that your table consists a primary key.
This thread is locked for new responses. Please post your comments and questions as a
If required, refer to the URL of this page in your
order of the events in a web form
Return to Discussion Forum
Post New Message
Is there any expert to solve this?
what is difference between String and string(data type) in c#?
what is a resource file...
Horizontal Scroll Bar for a listview control
Anil Kumar ...
Asheej T K
Last 7 Days
Asheej T K
Awards & Gifts
Articles Rss Feeds
Forum Rss Feeds
Revenue Sharing sites
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India
2005 - 2012 All Rights Reserved.
.NET and other trademarks mentioned in this site belong to Microsoft and other respective trademark owners.
Articles, tutorials and all other content offered here is for educational purpose only.
We are not associated with Microsoft or its partners.