How do you insert multiple rows from a grid view to database
table under a single transaction?



How do you insert multiple rows from a grid view to database table under a single transaction?..

Answer / ashish saxena

It can be done using SQL BulkCopy Object.

Is This Answer Correct ?    7 Yes 6 No

Post New Answer

More ASP.NET Interview Questions

Why we use content place holder in asp.net?

0 Answers  


What is the use of The Page.Master Property?

1 Answers  


what is the difference between server.Transfer and response.redirect in .net

1 Answers  


What is the use of autowireup in asp.net?

0 Answers  


What is the function of new view engine in asp.net? : asp.net mvc

0 Answers  


What is form method?

0 Answers  


Why and where this web.config file is used?

0 Answers   Amazon,


To redirect the user to another page which method do we use without performing a round trip to the client?

0 Answers   Siebel,


Hello, Using Visual Studio 2005 (VB) I am working to create a Web Site implementing the following: Within a gridView I have placed a dropdownlist control with a DataSourceID="SDSLkupList". SDSLkupList is a sqlDataSource used to store a lookup list for dropdownlist translation from ID to text. SDSLkupList contains the translation text and other fields related to the dropdown selection ID. (Thought it would be efficient to get everything at the same time.) I would like to provide the user the ability to select from the dropdownlist and, based on the selection, use labels to list related columns stored on the SDSLkupList in separate gridView columns. I have read that SqlDataSources are not meant to be used for individual controls. Since SDSLkupList contains all related information, is there a way to do a find using the dropdownlist selectedValue? (I was not able to discover one.) Otherwise, what should I use? It would need to set the labels on the gridView DataRowBound event as well as the SelectedIndexChanged events. Has anyone done this? Any help would be appreciated. Thanks in Advance. Neal

0 Answers  


In asp.net application, if a webpage or total application seems too slow or getting delayed to load completely in the browser. As a developer, what are the checkings or actions you will take in the application or server side to rectify the slowness or delay load or which are the factors related to this issue? How we can trace it?

1 Answers  


What are HTTP handlers in ASP.NET?

0 Answers   MindCracker,


can we pass coditions in swtich case?

3 Answers  


Categories