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 are the advantages of Ajax?

1 Answers  


What is the limitation of AJAX ?

0 Answers  


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

2 Answers   Hoch Technologies,


What does the dynamicpopulateextender control do? : asp.net ajax

0 Answers  


What is the difference between proxied and proxyless calls in AJAX?

1 Answers  


Why did ajax kill himself?

0 Answers  


What are the differences between ajax and javascript?

0 Answers  


How do I handle the back and forward buttons in ajax?

0 Answers  


Is it possible to use fileupload control within the update panel?

0 Answers  


Describe the accordionextender control?

0 Answers  


Should I consider ajax?

0 Answers  


Why do we need ajax?

0 Answers  


Categories