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

How do you declare delegates and are delegates and events one and the same and explain how do you declare delegates and invoke them ?

1 Answers MMTS,

Why does a user need nothing more than a Web browser to view ASP.NET pages?

1 Answers

Should validation (did the user enter a real date) occur server-side or client-side? Why?

4 Answers Siebel Systems,

if i have placed the button control with the OnClick event like <asp:Button ID="mybutton" runat="server" Text="Insert" onclick="mybutton_Click" /> and some other controls(buttons, textboxes) in .aspx page. When i run the page, the button displays in the page source of the browser like <input type="submit" name="mybutton" value="Insert" id="mybutton" /> here, it does not display the onclick event, then how the page calls the button click on the server side, how the server side identify which button cause the submit, and how this page moves to the server side.

1 Answers

What is state management in asp.net with example?

0 Answers

What is CLS?

5 Answers IBM, PrimeLine, TCS,

What is query string? What are its advantages and limitations?

0 Answers

How to disable SOAP1.2 in Web Services?

1 Answers

What are the features of asp.net mvc?

0 Answers

Types of authentications in ASP.NET ?