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
Differentiate between file-based dependency and key-based dependency.
What are the events in a page life cycle?
What are the navigation ways between pages available in ASP.NET?
How does session work?
How to register exception filter globally?
1.how to encrpt query string in asp.net? 2.there are 10000 records then i wnat display 5000 records one gridview and 5000 records another grid view what is the process?
How information about the user's locale can be accessed?
What does it mean your session has timed out?
What are the advantages of using session?
What is a user developed application?
What are web server controls in asp.net?
Define globalization and localization.
What are sql notifications and sql invalidations?
What are the properties of the eventargs argument when capturing keyboard events?
what is publisher?