How will you update multiple records in a single shot?
From an ASP.net appli to SQL Serevr
- 2 Answers
- 5089 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 |
What is asp.net ajax? : asp.net ajax
When should we use a java applet instead of ajax?
What are synchronous and asynchronous ajax requests?
What will happen with click of browser "back" button among asynchronous requests?
What is the basic goals of AJAX ?
What are all the technologies used by Ajax?
What is xmlhttprequest object in ajax? How can you xmlhttprequest object?
Would we be able to settle the updatepanel controls?
What are the important methods of xmlhttprequest?
Describe the animation extender control and the method by which this control is utilized?
What are the protocols and forms in ajax?
what are difference between server-side ajax framework and client-side ajax framework?
ASP 
