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
When should I use an java applet instead of ajax?
Why do you use ajax?
What parts of the html_ajax api are stable?
is the xmlhttprequest object part of a w3c standard?
Is it true that ajax is code browser compatible?
What are the common ajax frameworks?
What are Ajax applications?
What are the benefits of ajax over java applet?
What are the different ways to pass parameters to the server? : asp.net ajax
What is use of Update Panel control in Ajax toolkit?
What is synchronous request in ajax?
How many validation controls are available in asp.net ajax 4.0? : asp.net ajax
Do we have to use http get/post for the ajax calls?
Is it possible to set session variables from javascript?
What are the differences between ajax and javascript?