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
4469 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

I have one application, one user purchase some products in my application? and another person came he is also purchase some products?how can we identify which user purchase which items? my answer is by using session id? but i dont know how? can u give me programming for that?

1 Answers

can i call the java script to code behind file?if yes how?

4 Answers Wipro,

What are cao and sao.

0 Answers

How do we sort the data from a dataset?

0 Answers

What is difference between URL and URI?

0 Answers MCN Solutions,

What is the use of worker process in asp.net?

0 Answers

Less than one page, how many windows will you be able to maintain?