VistaDBCommandBuilder Class
In This Topic
Automatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated VistaDB database.
Syntax
'Declaration
<System.ComponentModel.DesignerCategoryAttribute("Component")>
Public NotInheritable Class VistaDBCommandBuilder
Inherits System.Data.Common.DbCommandBuilder
'Usage
Dim instance As VistaDBCommandBuilder
[System.ComponentModel.DesignerCategory("Component")]
public sealed class VistaDBCommandBuilder : System.Data.Common.DbCommandBuilder
Example
Private Sub Example(ByVal SelectString As String, ByVal ConString As String)
Me.mAdapter = New VistaDB.Provider.VistaDBDataAdapter
Me.mAdapter.SelectCommand = New VistaDB.Provider.VistaDBCommand(SelectString, New VistaDBConnection(ConString))
Dim cmdBuilder As VistaDB.Provider.VistaDBCommandBuilder = New VistaDB.Provider.VistaDBCommandBuilder(Me.mAdapter)
Me.mAdapter.InsertCommand = cmdBuilder.GetInsertCommand
Me.mAdapter.UpdateCommand = cmdBuilder.GetUpdateCommand
Me.mAdapter.DeleteCommand = cmdBuilder.GetDeleteCommand
Me.mAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
' ORDER IS VERY IMPORTANT HERE STEP THEN SEED
mData = New DataSet
mAdapter.Fill(mData)
mData.Tables!Table.Columns!ID.AutoIncrement = True
mData.Tables!Table.Columns!ID.AutoIncrementStep = -1
mData.Tables!Table.Columns!ID.AutoIncrementSeed = -1
mData.Tables!Table.Columns!ID.ReadOnly = False
End Sub
static void Example( string SelectString, string ConnString )
{
VistaDBDataAdapter mAdapter = new VistaDBDataAdapter();
mAdapter.SelectCommand = new VistaDBCommand(SelectString,
new VistaDBConnection(ConnString));
VistaDBCommandBuilder cmdBuilder = new VistaDBCommandBuilder(mAdapter);
mAdapter.InsertCommand = cmdBuilder.GetInsertCommand();
mAdapter.UpdateCommand = cmdBuilder.GetUpdateCommand();
mAdapter.DeleteCommand = cmdBuilder.GetDeleteCommand();
mAdapter.MissingSchemaAction = System.Data.MissingSchemaAction.AddWithKey;
DataSet mData = new DataSet();
mAdapter.Fill(mData);
// NOTE: The order of these two is IMPORTANT
// STEP MUST come before SEED
mData.Tables[0].Columns[0].AutoIncrementStep = -1;
mData.Tables[0].Columns[0].AutoIncrementSeed = -1;
mData.Tables[0].Columns[0].ReadOnly = false;
}
Inheritance Hierarchy
System.Object
System.MarshalByRefObject
System.ComponentModel.Component
System.Data.Common.DbCommandBuilder
VistaDB.Provider.VistaDBCommandBuilder
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also