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
Describe the formats and protocols used by ajax?
Is it compulsory to have script manager on the page when you are using any control of ajax control tool kit?
Is the server or the client in control in ajax?
What is the asp.net ajax framework?
What is the xmlhttprequest object?
Is ajax a framework?
Which are the knowledge requirements for personal ajax functionality?
What is ajaxcontrol toolkit?
Is it possible to set session variables from javascript?
How do I handle concurrent ajax requests?
Do ajax applications always deliver a better experience than traditional web applications?
Is there any use abilities problems in ajax?
What is asp.net 2.0 ajax?
Don't be too quick to dump your plugin or applet based portions of your application. While ajax and dhtml can do drag and drop and other advanced user interfaces there still limitations especially when it comes to browser support. Plugins and applets have been around for a while and have been able to make ajax like requests for years. Applets provide a great set of ui components and apis that provide developers literally anything.
What is ajax and how does it work?