Command Builder:
A command builder is
an ADO.NET object that lets you create command objects for a data adapter's
insert, update, delete statement is based on the adapter's select statement.
that way, you don't have to worry about coding these statements and creating
these command yourself.
create a
SqlCommandBuilder: There are two way to create SqlCommandBuilder in
ADO.NET. That are:
Properties of
command builder:
-
DataAdapter:
The Data Adapter that contain the select statement that will be used to
generate insert, update, delete statements.
-
Refresh
Schema: Refresh the schema information that's used to generate the
insert, update, delete statements.
Code that creates
a SqlCommandBuilder Object:
Imports
System.Data.SqlClient
Module Module1
Sub Main()
Dim da As
New SqlDataAdapter
Dim cmdb As
New SqlCommandBuilder()
cmdb.da = "Table_name"
End Sub
End
Module
Description:
-
You can use a command builder to generate
Insert, update and delete command for a data adapter from the select command
for the data Adapter. for this work, the select command must contain a
select statement.
-
The data Adapter value is set to the
value that you pass to the constructor for the Command Builder. if you don't
pass values, you must set the properties after you create a command builder.
Note:
-
A command Builder can't be used with a
select command that contain the name of a store procedure or a select
statement that retrieve data from more than one table.
-
The select statement associate with data
adapter must include a primary key or a unique column from a table.