How will you update multiple records in a single shot?
From an ASP.net appli to SQL Serevr
Answer Posted / 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 |
Post New Answer View All Answers
How to cancel the current request in ajax?
What are the common ajax frameworks?
Easy trough that the classical web applications are harder to make than ajax applications?
What are the new features of asp.net ajax 4.0? : asp.net ajax
What is the difference between synchronous postback and asynchronous postback? : asp.net ajax
Is it true that ajax is code browser compatible?
How to control how long an ajax request may last?
How can javascript be debugged?
Which control you need to place on the page to show loading image?
What will happen with click of browser "back" button among asynchronous requests?
Is ajax just another name for xmlhttprequest?
What technologies are being used in ajax? : asp.net ajax
In what way are proxyless calls different than the proxied calls in ajax?
How ajax work ?
What are the differences between ajax and javascript?