Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

When should I use an java applet instead of ajax?

913


Why do you use ajax?

928


What parts of the html_ajax api are stable?

928


is the xmlhttprequest object part of a w3c standard?

928


Is it true that ajax is code browser compatible?

1053


What are the common ajax frameworks?

974


What are Ajax applications?

1508


What are the benefits of ajax over java applet?

901


What are the different ways to pass parameters to the server? : asp.net ajax

1000


What is use of Update Panel control in Ajax toolkit?

1016


What is synchronous request in ajax?

916


How many validation controls are available in asp.net ajax 4.0? : asp.net ajax

974


Do we have to use http get/post for the ajax calls?

1025


Is it possible to set session variables from javascript?

957


What are the differences between ajax and javascript?

944