Interested to Buy Any Domain ? << Click Here >> for more details...
Way of updating a table other than stored procedure and
hard coded query?
- 2 Answers
- 5337 Views
- I also Faced
- E-Mail Answers
Answer Posted / javed khan
The SqlDataAdapter enables us to fill a DataSet and Update changes back to the data base.We don't have to worry about opening and closing the SqlConnection, writing update command because the SqlDataAdapter does it automatically. A SqlCommandBuilder populates insert, update, and delete commands based on the SqlDataAdapter's select statement. Use the Fill method of the SqlDataAdapter to fill a DataSet with data. Call the SqlDataAdapter's Update method to push changes back to a data base.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to add DateTime Control in normal DataGrid Server Control?
What is difference between cookies and cache?
What is difference between ispostback and autopostback in asp net?
What is the caspol.exe tool used for?
How do you design a website with multilingual support in ASP.NET ?
Where you store Connection string in "Web.Config" file in ASP.NET?
Differentiate between Server.Transfer and Response.Redirect with functionality? Why we can choose one over the other?
Explain the Order of events in an asp.net page?
What is state management in .net?
Which object encapsulates state or data of a user?
Is asp.net mvc still used? : Asp.Net MVC
What are the new navigation controls in asp.net 2.0?
Can I have a unique key as foreign key?
How is it possible for .NET to support many languages?
What is in a session cookie?
