Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Define common type system?

915


How to use push notification?

983


What are the main requirements for caching?

984


Which is better viewstate or session?

891


What are validators and list some validators of asp.net?

919


What is the current version of asp.net?

938


What are the Types of state management techniques

975


Give a few examples of page life cycle events.

1075


Explain server control extensibility with reference to asp.net 2.0 ?

928


Explain what benefit does your code receive if you decorate it with attributes demanding specific security permissions?

946


Do you know about caching with the datasource controls?

850


How you will manage the state of ASP.NET controls?

999


Which dll handles the request of .aspx page?

919


What is asp net objects?

979


What is the part of url?

919