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

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

Question Posted / sani

2 Answers
5294 Views
I also Faced
E-Mail Answers

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

Explain how asp.net page works?

0 Answers

What is the difference of a LEFT JOIN and an INNER JOIN statement? What is a Cartesian product? What causes it?

1 Answers Syntax Softtech,

What is considered a service provider?

0 Answers

Explain difference between dataset and recordset?