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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

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

530


What is the flow of processing of the request? : asp.net mvc

508


How ASP and ASP.NET page works? Explain about asp.net page life cycle?

581


What is the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc

536


What is the benefit of WebAPI over WCF?

564






How will you load dynamic assembly? How will create assesblies at run time?

457


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

591


What are the asp.net 2.0 features?

547


What is the use of web.config file?

529


Explain exception filters?

585


Describe the master page.

552


What is the use of ASP.NET routing?

556


What are validator? Name the validation controls in asp.net?

497


What is difference between session and cookies in asp net?

500


How can u debug your .net application?

576