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 do we get the xmlhttprequest object?
What browsers does html_ajax work with?
How ajax work ?
Easy trough that the classical web applications are harder to make than ajax applications?
Which two methods are used for handling cross-domain ajax calls ?
What is the necessary control that must put in order to use Ajax Controls?
What are the types of open() method used for xmlhttprequest?
What is the role of scriptmanager in ajax?
Define json?
Who is using ajax?
What is the role of the callback function in ajax?
Will html_ajax integrate with other javascript ajax libraries such as scriptaculous?
Does java have support for comet style server-side push?
What are asp.net ajax 4.0 validation controls?
What is the difference between a destructor and a garbage collector?