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?

Answers were Sorted based on User's Feedback



Way of updating a table other than stored procedure and hard coded query?..

Answer / 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

Way of updating a table other than stored procedure and hard coded query?..

Answer / raviraj

Try with transactions whose code is terse and comprehensive.
transactions offer the best alternative solutions for
updating the table content.You can either commit or
rollback the transcation by using T-sql update cpmmand in
the explicit transcation based on the where condition.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More ASP.NET Interview Questions

What is the use of HttpHandlers? When to use this?

0 Answers   Wipro,


Do I need to have the latest version of windows media player installed?

0 Answers  


Any disadvantages in Dataset and in reflection ?

0 Answers   DELL, Digital GlobalSoft,


How can we inherit a static member?

0 Answers  


What is state management in asp.net and define Client-side state management and Server-side state management?

2 Answers   TVS,


What property must you set, and what method must you call in your code, in order to bind the data from a data source to the Repeater control?

1 Answers   Siebel,


What is HTTPContext and HTTPModule. What is the use of them?

1 Answers  


What are the different Key TreeView Properties in Asp.net 2.0?

1 Answers   TCS,


What is strong name and which tool is used for this?

4 Answers   Accenture,


What is the use of data set in asp.net?

0 Answers  


Which property is used to identify the Page is Post Back in ASP.NET?

0 Answers   Sans Pareil IT Services,


how we declare interface

2 Answers  


Categories