How will you update multiple records in a single shot?
From an ASP.net appli to SQL Serevr
- 2 Answers
- 5132 Views
- Hoch Technologies, I also Faced
- E-Mail Answers
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 handle multiple async ajax requests?
What is the difference between synchronous postback and asynchronous postback? : asp.net ajax
Are there any frameworks available to help speedup development with ajax?
Will html_ajax integrate with other javascript ajax libraries such as scriptaculous?
Is json is a programming language?
Is it compulsory to have script manager on the page when you are using any control of ajax control tool kit?
Cannot parse xml generated by jsp I am generating an xml using jsp, when I run the jsp in ie it shows the xml as per dom, but when I try to parse it using javascript , the command xmldoc.documentelement ?
Which request is better with ajax, get or post?
Does ajax have significant accessibility or browser compatibility limitations? Do ajax applications break the back button? Is ajax compatible with rest? Are there security considerations with ajax dev
How does an ajax call work?
What is the role of scriptmanager in ajax?
Describe the accordionextender control?
How do we get the xmlhttprequest object in ajax?
What is the importance of client-side libraries? : asp.net ajax
What javascript libraries and frameworks are available?
