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 ajax work ?
Can I use asp.net ajax with any other technology apart from asp.net?
What is the purpose of xmlhttprequest?
What is the importance of client-side libraries? : asp.net ajax
How can javascript be debugged?
Should I consider ajax?
What is the difference between json and ajax?
What are the advantages and disadvantages of ajax?
Which request is better with ajax, get or post?
What are the requirements to run asp.net ajax applications on a server?
is the xmlhttprequest object part of a w3c standard?
Does this mean adaptive path is anti-flash?
What are the new controls introduced in asp.net ajax control toolkit? : asp.net ajax
Are ajax applications easier to develop than traditional web applications?
What are the new features of asp.net ajax 4.0? : asp.net ajax