How can we insert 100 records @ a time without using for loop into the databse

Answer Posted / sudhir

By use of SQLcommandbuilder, Sqldataadapter and Dataset u can direct update or insert whole datatable or dataset onto database by useinf sqldataadapter.update(datatable/dataset) method

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between float and decimal?

718


What is the base class in .net from which all the classes are derived from?

711


Explain how to parse a datetime string?

670


Can abstract class be sealed in c#?

648


Enlist all the components of an ado.net framework?

647


How do I do implement a trace and assert?

764


Can we override main method in c#?

693


What do you mean by streamreader/streamwriter class in c#?

705


List some of the common data providers for ado.net framework?

630


What is int32?

680


How is method overriding different from overloading?

759


How do I convert a string to an int in c#?

708


For read-only operation which property you have to designated?

810


Explain the difference between “constant” and “read-only” variables used in c#?

765


Why should I use interface in c#?

708