How will you update multiple records in a single shot?
From an ASP.net appli to SQL Serevr
- 2 Answers
- 5114 Views
- Hoch Technologies, I also Faced
- E-Mail Answers
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 |
Describe the process and benefits of using the always visible control extender?
How do we get the xmlhttprequest object?
what are difference between server-side ajax framework and client-side ajax framework?
Are there any frameworks available to help speedup development with ajax?
How can we handle concurrent requests?
What will happen with click of browser "back" button among asynchronous requests?
What are the types of open() method used for xmlhttprequest?
Where AJAX cannot be used?
Is it possible to upload a file using Ajax ? Reason
When do I use a synchronous versus asynchronous request?
What are the benefits of ajax?
Why is ajax called ajax?
ASP 
