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
What is a session in programming?
What is the default Orientation property in a Menu control?
What is a postback ispostback and autopostback in asp net?
What will happen if the server confugration file and the application confugration file have different values for sassion state ASP.NET?
What are the different types of proxy patterns?
How do you secure your connection string information?
What are the contents of cookie?
Define viewstate in .net?
What is advantage of asp.net?
Explain the difference between sql invalidation and sql notification.
Which validator control you use if you need to make sure the values in two different controls matched?
What is custom attribute? How to create?
Explain managed code an un-managed code.
if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....
What is the difference between file-based dependency and key-based dependency?