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



How will you update multiple records in a single shot? From an ASP.net appli to SQL Serevr..

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

How will you update multiple records in a single shot? From an ASP.net appli to SQL Serevr..

Answer / darshit

it does not support in Sql Server 2005

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More AJAX Interview Questions

Why is html_ajax having stability issues on some installations?

0 Answers  


How can we handle exception handling in Ajax?

1 Answers  


What is an ajax request?

0 Answers  


Can we nest the updatepanel controls? : asp.net ajax

0 Answers  


What are the advantages and disadvantages of ajax?

0 Answers  






What is the purpose of xmlhttprequest?

0 Answers  


Explain the step property of the numericupdownextender control? : asp.net ajax

0 Answers  


What is synchronous request in ajax?

0 Answers  


Explain the updatepanel control? : asp.net ajax

0 Answers  


whether QTP sopports the ajax application

1 Answers   Wipro,


Is it possible to upload a file using Ajax ? Reason

7 Answers   IBM,


Will html_ajax integrate with other javascript ajax libraries such as scriptaculous?

0 Answers  


Categories