How will you update multiple records in a single shot?
From an ASP.net appli to SQL Serevr
Answers were Sorted based on User's Feedback
Answer / mithun
Create a data table. add mulitple records to it. pass it as datatable to stored procedure.
in DAO, pass datatable as single parameter of type SqlType.Structured.
in SQL, create a user defined datatype of table with same structure u pass from web. select the column values from table datatype an insert into table.
| Is This Answer Correct ? | 2 Yes | 1 No |
What are the disadvantages of Ajax?
What's the difference in HTML AJAX, ASP.Net AJAX?
What are the common problems (errors) you get while implementing AJAX?
What are the advantages of Ajax?
What is the difference between json and ajax?
How to control the duration of an Ajax request?
How we can send data to server using ajax?
What's new in .Net 3.5
What role of #&& in querystring?
What meaning has asp.net ajax?
Describe the accordionextender control? : asp.net ajax
What are the types of post back in Ajax?