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 will html_ajax have a stable release?
What are the extender controls? : asp.net ajax
Explain fetch api in javascript?
What are the different ready states of a request in ajax?
What is ajax and how does it work?
Who's using ajax?
In what way are proxyless calls different than the proxied calls in ajax?
Does ajax have the same meaning as xmlhttprequest?
What are ajax limitations?
How does html_ajax compare with the xajax project at sourceforge?
Easy trough that the classical web applications are harder to make than ajax applications?
How do I access data from other domains to create a mashup with java?
Can I use ajax with seam?
What is the difference between json and ajax?
What are asp.net ajax 4.0 validation controls?