Way of updating a table other than stored procedure and
hard coded query?
- 2 Answers
- 4725 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
What are the ways to sending the data in ASP.NET page?
What are the memory-mapped files?
How many types of triggers are there in update panel?
What is view state and how it works in asp net?
What are ASHX files?
What do you mean by query string?
Can we handle the error and redirect to some pages using web.config?
Can viewstate be accessed in another page?
When you use Ajax controls in the ASP.NET application?
What is in a session cookie?
Explain the advantages of asp.net.
What are the data controls available in asp.net?
Explain how viewstate is being formed?
Explain the use of dataadapter.
What are client activated objects?
