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 use of HttpHandlers? When to use this?
Do I need to have the latest version of windows media player installed?
Any disadvantages in Dataset and in reflection ?
0 Answers DELL, Digital GlobalSoft,
How can we inherit a static member?
What is state management in asp.net and define Client-side state management and Server-side state management?
What property must you set, and what method must you call in your code, in order to bind the data from a data source to the Repeater control?
What is HTTPContext and HTTPModule. What is the use of them?
What are the different Key TreeView Properties in Asp.net 2.0?
What is strong name and which tool is used for this?
What is the use of data set in asp.net?
Which property is used to identify the Page is Post Back in ASP.NET?
0 Answers Sans Pareil IT Services,
how we declare interface
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)