Way of updating a table other than stored procedure and
hard coded query?
Answers were Sorted based on User's Feedback
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 |
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 |
What is the difference between a cookie and a pixel?
What are themes and skins in 2.0, explain usage scenario?
Define common type system?
How will you load dynamic assembly? How will create assesblies at run time?
Let's say I have an existing application written using vb6 and this application utilizes windows 2000 com+ transaction services. How would you approach migrating this application to.net?
What is the difference between user control and custom control?
What is session mode in asp.net?
Describe how passport authentication works.
What is in a session cookie?
Explain server control extensibility with reference to asp.net 2.0 ?
What is a postback url?
What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)