How will you update multiple records in a single shot?
From an ASP.net appli to SQL Serevr
Answers were Sorted based on User's Feedback
Answer / 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 |
What javascript libraries and frameworks are available for ajax support?
What is the name of object used for AJAX request?
How can we handle exception handling in Ajax?
How can we handle concurrent requests?
How ajax is different?
Brief about ajax?
Should I use xml or text, javascript, or html as a return type?
Is ajax built into javascript?
What are all the security issues of Ajax?
What is the asp.net ajax framework? What versions have been released so far?
What is Script Manager?
When will html_ajax have a stable release?