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

What is the importance of client-side libraries? : asp.net ajax

0 Answers  


Is it compulsory to have script manager on the page when you are using any control of ajax control tool kit?

0 Answers  


What are all the features of Ajax?

1 Answers  


What is the name of the DLL that contains Ajax control tool kit?

1 Answers  


What is polling in ajax.

0 Answers  


Is there any use abilities problems in ajax?

0 Answers  


Describe ajax control extender toolkit? : asp.net ajax

0 Answers  


What is json? : asp.net ajax

0 Answers  


Is ajax considered a programming language?

0 Answers  


Where AJAX cannot be used?

1 Answers  


What are all the browsers support AJAX?

1 Answers  


What is the basic goals of AJAX ?

0 Answers  


Categories