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 will html_ajax have a stable release?

973


What are the extender controls? : asp.net ajax

929


Explain fetch api in javascript?

955


What are the different ready states of a request in ajax?

909


What is ajax and how does it work?

924


Who's using ajax?

1270


In what way are proxyless calls different than the proxied calls in ajax?

900


Does ajax have the same meaning as xmlhttprequest?

931


What are ajax limitations?

840


How does html_ajax compare with the xajax project at sourceforge?

873


Easy trough that the classical web applications are harder to make than ajax applications?

872


How do I access data from other domains to create a mashup with java?

1026


Can I use ajax with seam?

898


What is the difference between json and ajax?

935


What are asp.net ajax 4.0 validation controls?

859