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
- 5213 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
Explain the difference between sql invalidation and sql notification.
Describe the difference between inline and code behind - which is best in?
Why we use content place holder in asp.net?
Explain the difference between dataset and datareader.
How can you use a custom controls in ASP.NET application?
Error : The operation couldn’t be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction.00000110 oledb provider for linked server returned message the partner transaction manager has disabled its support for remote/network transactions. I can able to execute the stored procedure in sql server but when i run the web page getting error like above. I did all the configuration. what is the solution?
What is role-based security in asp.net?
How to register exception filter globally?
Fetch one page value to another page without using state-managment ?
Define reflection in .net?
Define application state variable and session state variable?
What is _viewstart?
What is the difference between server-side scripting and client-side scripting?
What is the use of the tag in the web.config file?
What is application variable in asp.net?
