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


Please Help Members By Posting Answers For Below Questions

What are the different authentication modes in asp.net?

615


From which base class all web forms are inherited?

599


To redirect the user to another page which method do we use without performing a round trip to the client?

617


What are httphandlers and httpmodules and difference between them?

615


Can a .net web application consume java web service?

608






What is voluum?

639


Difference between DataGid and Girdview? Difference b/w .Net 2.0, 3.0 and 3.5 ? Diff b/w dispose & Finialize Methods?

2144


Explain Apache web servers ? How can you get ASP.NET running in Apache web servers - why should you do this?

600


Explain the features that make asp.net more used framework? : asp.net mvc

569


In Code-Behind class which kind of code (server or client) is found ?

680


How many types of cookies are there in asp.net?

622


What do you mean by authentication?

619


How can I open ashx file in mobile?

719


What are the differences between code behind and code inline?

601


can any one find and tell the difference between dot net and php which one is best ? which one we get more salary? which one is stable and which one is best for freshers and also better in future and carrer ? which one we wil get more salary sir ? please send ur valuable suggestions to kiranpulsar2007@gmail.com

1570