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 |
Brief about ajax?
Is it possible to use fileupload control within the update panel?
How do I access data from other domains to create a mashup with java?
What is the response time when using ajax?
Is ajax just another name for xmlhttprequest?
Differentiate between synchronous and asynchronous ajax requests.
Briefly describe asp.net ajax framework? : asp.net ajax
What is asynchronous request in ajax?
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?
Does ajax work with java?
Which are the problems that can be fixed using ajax and what is the actual meaning of ajax?
Define the role of the Update Panel?