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 different readystate in ajax?
The components in the asp.net 2.0 ajax packaging?
What are the types of send() method used for xmlhttprequest?
Does ajax work with java?
What is the difference between a destructor and a garbage collector?
What is Synchronous and Asynchronous AJAX request.
Describe ajax control extender toolkit? : asp.net ajax
Diff b/w javascript and jquery
What are all the browsers support AJAX?
Are there any frameworks available to help speedup development with ajax?
What are the real web applications of ajax currently running in the market?
What is the use of the scriptmanager control in ajax? : asp.net ajax