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

Do you know using sql cache invalidation?

0 Answers

How to use ipostback?

0 Answers

What ASP.NET object encapsulates the state of the client and the browser? a) The Session object b) The Application object c) The Response object d) The Request object e) The Server object

7 Answers Bunzl Vending, Syntax Softtech,

What is microsoft windows sharepoint services?

0 Answers

In asp.net 3.5 we can go one page to onther page without using statemanagment concept?

1 Answers ANR, Google, TCS,

Which tools of web site Administartion tool do you use to manage user,roles and rules?

2 Answers

How would one do a deep copy in .NET?

6 Answers TCS,

i want to develope a page for online test using asp.net with c#.net. so, how to insert the questions in the database sqlserver2000 and how to pick the questions randomly when user login for test. plz send the code for this....

3 Answers Chaitanya, Crysalis, CTS, HCL, Sein Infotech, TCS,

How you will handle session when deploying application in more than a server? Describe session handling in a webfarm, how does it work and what are the limits?

3 Answers CoreObjects,

Can we set which type of comparison we want to perform by the CompareValidator control?

0 Answers MindCracker,

What is early binding and Late binding. Difference which is better ?

2 Answers DELL,

What is difference between or and orelse?

0 Answers

For more ASP.NET Interview Questions Click Here