AddCommand(IDbCommand,String) Method

In This Topic

Syntax
Example
Requirements
See Also

Adds a command to the provider, resulting in an additional table in the Designer.

Syntax

public void AddCommand( 
   IDbCommand command,
   string tableName
)

public:
void AddCommand( 
   IDbCommand^ command,
   String^ tableName
)

'Declaration
 
Public Overloads Sub AddCommand( _
   ByVal command As IDbCommand, _
   ByVal tableName As String _
)

Parameters

command: The command to add.
tableName: The name for the resulting table.

Example

C#
VB.NET

OleDbCommand command = new OleDbCommand("Select * from [Customers]", conn);
OleDbCommand command2 = new OleDbCommand("Select * from [Orders]", conn);

DbCommandSetDataProvider provider = new DbCommandSetDataProvider();
provider.AddCommand(command, "Customers");
provider.AddCommand(command2, "Orders");
provider.AddRelation("Customers2Orders", "Customers", "Orders", "CustomerID", "CustomerID");

LL.DataSource = provider;
LL.Design();

Dim command As New OleDbCommand("Select * from [Customers]", conn)
Dim command2 As New OleDbCommand("Select * from [Orders]", conn)

Dim provider As New DbCommandSetDataProvider()
provider.AddCommand(command, "Customers")
provider.AddCommand(command2, "Orders")
provider.AddRelation("Customers2Orders", "Customers", "Orders", "CustomerID", "CustomerID")

LL.DataSource = provider
LL.Design()

Requirements

Platforms: Windows 10 (Version 21H2 - 23H2), Windows 11 (21H2 - 22H2), Windows Server 2016 - 2022
.NET: .NET Framework 4.8, .NET 6, .NET 8, .NET 9

Reference

DbCommandSetDataProvider Class
DbCommandSetDataProvider Members
Overload List

Send Feedback