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
How can we Validate a Controls in ASP.NET page using JavaScript?
Explain ViewState?
How does output caching work in ASP.NET?
How can we secure the data which is send from client side to server? Like the login id and paasword needs to be authenticated on the server but we cannot send it in plain text into the server.One more thing we are not using the SSL here.
Explain asp.net web forms.
Explain what the contents of cookie?
What is the Intermittent crashing of application in production?
Explain advantages of caching?
What is difference between asp.net and asp?
Why is an object pool required?
List the types of authentication supported by asp.net?
Is it possible to write code in many languages in one asp.net project?
What is the difference between page directive include and action tag include?
Is a dll file an executable?
What is cross page posting in asp net?