What Is The Use Of Commandbuilder ?

1.	What Is The Use Of Commandbuilder ?
Answer» CommandBuilder builds “Parameter” objects automatically. Below is a simple code which uses commandbuilder to load its parameter objects. DIM pobjCommandBuilder As New OleDbCommand Builder (pobj DataAdapter) pobjCommandBuilder.DeriveParameters(pobjCommand) Be careful while USING “DeriveParameters” METHOD as it NEEDS an extra TRIP to the Datastore which can be very inefficient CommandBuilder builds “Parameter” objects automatically. Below is a simple code which uses commandbuilder to load its parameter objects. Be careful while using “DeriveParameters” method as it needs an extra trip to the Datastore which can be very inefficient

Answer»

CommandBuilder builds “Parameter” objects automatically.

Below is a simple code which uses commandbuilder to load its parameter objects.

DIM pobjCommandBuilder As New OleDbCommand Builder (pobj DataAdapter) pobjCommandBuilder.DeriveParameters(pobjCommand)

Be careful while USING “DeriveParameters” METHOD as it NEEDS an extra TRIP to the Datastore which can be very inefficient

CommandBuilder builds “Parameter” objects automatically.

Below is a simple code which uses commandbuilder to load its parameter objects.

Be careful while using “DeriveParameters” method as it needs an extra trip to the Datastore which can be very inefficient

Discussion