1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

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

Question Posted / sani

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 type of code (server or client) is found in a Code- Behind class?

2 Answers  

How to implement caching?

2 Answers   Infosys, Microsoft,

Where can i get Latest Microsoft .Net Certification Dumps & what Types of .Net Certifications are there?

2 Answers   Protech,

In SP has contains 10 query,By Using Dataset Object I need to fetch 8th query of records? How?

5 Answers  

If you have an application with multiple security levels though secure login and my ASP.NET web appplication is spanned across three web-servers by using round-robbin load balancing. Explain which is the best approach to maintain login-in state for the users?

0 Answers   Siebel,




main difference between asp.net2.0,asp.net1.1,asp.net1.0

1 Answers   Northgate is,

How to stop the inheritance?

2 Answers   TCS,

what is strong name?

4 Answers   Fidelity, Infosys, Microsoft, Shriram Value Services,

how we declare interface

2 Answers  

What is the concept of view state in asp.net?

0 Answers  

What are server side controls?

0 Answers  

Explain the difference between debug.write and trace.write? When should each be used?

0 Answers  

For more ASP.NET Interview Questions Click Here
Categories