Way of updating a table other than stored procedure and
hard coded query?
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
Can I have a unique key as foreign key?
Which namespace is used by ado.net?
How do you design a website with multilingual support in ASP.NET ?
What are validator? Name the validation controls in asp.net? How do you disable them?
In order to bind the data from a data source to the Repeater control what property is set and what method must you call in your code,?
What is the purpose of using MVC programming pattern in ASP.NET?
Explain the difference between Web Garden and Web Farm?
What is a web server? What are the load limits in it?
how to debug web services on consumer side?
If you are using two select queries and retrieving data. how do you access second query's result set using data reader?
What is preprocessor in .net? Where it use?
What is the advantage of mvc over asp.net? : Asp.Net MVC
What are directives in asp.net? List down all the important directives.
Why we use asp.net for website development?
Define globalization and localization.