SqlDataAdapter has some of the functions like AddToBatch(), ClearBatch(), ExecuteBatch(). What are they used for?

I need an example to understand this o开发者_StackOverflow中文版r some good articles would help

If you want to execute a number of commands in one batch, you can add them to a batch then execute it.

A batch is simply a collection of commands - sometimes you may want to send them all together to the database instead of one at a time.