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
What is the purpose of xmlhttprequest?
What's the difference in HTML AJAX, ASP.Net AJAX?
What are the properties of xmlhttprequest?
What is the asp.net ajax framework?
Is there any use abilities problems in ajax?
Why do we use the xmlhttprequest object in ajax? : asp.net ajax
What are limitations of ajax?
Who's using ajax?
What is xmlhttprequest object in ajax? How can you xmlhttprequest object?
What is the basic goals of AJAX ?
What are synchronous and asynchronous ajax requests?
Describe the process and benefits of using the always visible control extender?
How do I provide internationalized ajax interactions?
How ajax is different?
What are the differences between ajax and javascript?