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 javascript libraries and frameworks are available for ajax support?

1 Answers  


What is the name of object used for AJAX request?

1 Answers  


How can we handle exception handling in Ajax?

1 Answers  


How can we handle concurrent requests?

1 Answers  


How ajax is different?

1 Answers  


Brief about ajax?

1 Answers  


Should I use xml or text, javascript, or html as a return type?

1 Answers  


Is ajax built into javascript?

1 Answers  


What are all the security issues of Ajax?

1 Answers  


What is the asp.net ajax framework? What versions have been released so far?

1 Answers  


What is Script Manager?

1 Answers  


When will html_ajax have a stable release?

1 Answers  


Categories