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 |
How to handel error in ajax?
Who is using ajax?
What are the pre-requisites to execute AJAX applications on a server?
Which are the trigger types that we find in update panel?
Some of the google examples you cite don't use xml at all. Do I have to use xml and/or xslt in an ajax application?
Explain Ajax polling?
Is ajax just another name for xmlhttprequest?
What are the controls of the Script Management group?
Is it compulsory to have script manager on the page when you are using any control of ajax control tool kit?
Which two methods are used for handling cross-domain ajax calls ?
Describe how to handle concurrent ajax requests?
What does the dynamicpopulateextender control do? : asp.net ajax