SelectCommand Property (DbDataTable)

In This Topic

Gets or sets a SQL statement used to select records in the data source.

Syntax

Visual Basic
C#

'Declaration
 
Public Property SelectCommand As DbCommand

public DbCommand SelectCommand {get; set;}

Property Value

An System.Data.IDbCommand that is used during a fill operation to select records from the data source for placement in the DbDataTable.

Remarks

SelectCommand uses its own Connection if it is created. Otherwise SelectCommand uses Connection property.

If the SelectCommand property is not set, DbDataTable generates necessary SQL statements automatically.

Example

This sample shows how to use DbDataTable. The routine accepts DbDataTable-compatible object, IDbCommand implementor object, and IDbConnection implementor object as parameters. After SQL query text has been set the data is retrieved from the table.

csharp

public void UseDataTable(DbDataTable myDataTable, DbCommand myCommand, DbConnection myConnection)
{
  myDataTable.Connection = myConnection;
  myCommand.CommandText = "SELECT * FROM Dept";
  myDataTable.SelectCommand = myCommand;
  try
  {
    myDataTable.Active = true;
    foreach(DataRow myRow in myDataTable.Rows)
    {
      foreach(DataColumn myCol in myDataTable.Columns)
      {
        Console.Write(myRow[myCol]+"\t");
      }
      Console.WriteLine();
    }
  }
  finally
  {
    myDataTable.Active = false;
  }
}

Visual Basic

Public Sub UseDataTable(ByVal myDataTable As DbDataTable, ByVal myCommand As DbCommand, ByVal myConnection As DbConnection)
  myDataTable.Connection = myConnection
  myCommand.CommandText = "SELECT * FROM Dept"
  myDataTable.SelectCommand = myCommand
  Try
    myDataTable.Active = True
    Dim myRow As DataRow
    Dim myCol As DataColumn
    For Each myRow In myDataTable.Rows
      For Each myCol In myDataTable.Columns
        Console.Write(myRow(myCol) & Chr(9))
      Next myCol
      Console.WriteLine()
    Next myRow
  Finally
    myDataTable.Active = False
  End Try
End Sub

Reference

DbDataTable Class
DbDataTable Members
DeleteCommand Property
InsertCommand Property
UpdateCommand Property
QueryRecordCount Property

Send Feedback