combit List & Label 24 - .NET Online Web Help
AddCommand(IDbCommand,String) Method
Example 


combit.ListLabel24.DataProviders Namespace > DbCommandSetDataProvider Class > AddCommand Method : AddCommand(IDbCommand,String) Method

The command to add.

The name for the resulting table.

Adds a command to the provider, resulting in an additional table in the Designer.
Syntax
'Declaration
 
Public Overloads Sub AddCommand( _
   ByVal command As IDbCommand, _
   ByVal tableName As String _
) 
public void AddCommand( 
   IDbCommand command,
   string tableName
)
public:
void AddCommand( 
   IDbCommand^ command,
   String^ tableName
) 

Parameters

command

The command to add.

tableName

The name for the resulting table.

Example
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 Vista - Windows 10 Version 1809, Windows Server 2008 - 2016

See Also

Reference

DbCommandSetDataProvider Class
DbCommandSetDataProvider Members
Overload List