SqlDataTable Constructor(SqlCommand,SqlConnection)

On this page

Initializes a new instance of the SqlDataTable class.

Syntax

Visual Basic
C#


'Declaration Public Function New( _ ByVal selectCommand As SqlCommand, _ ByVal connection As SqlConnection _ )


public SqlDataTable( SqlCommand selectCommand, SqlConnection connection )

Parameters

selectCommand: A SqlCommand object used to select rows from the data source.
connection: A SqlConnection used to connect to the data source.

Example

This sample shows how to create a SqlDataTable and retrieve data from a table.

csharp


public void UseDataTable(SqlConnection myConnection) { SqlCommand myCommand = new SqlCommand("SELECT * FROM Test.Dept"); SqlDataTable myDataTable = new SqlDataTable(myCommand,myConnection); 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; } }

public void UseDataTable(SqlConnection myConnection)
{
  SqlCommand myCommand = new SqlCommand("SELECT * FROM Test.Dept");
  SqlDataTable myDataTable = new SqlDataTable(myCommand,myConnection);
  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 myConnection As SqlConnection) Dim myCommand As SqlCommand = New SqlCommand("SELECT * FROM Test.Dept") Dim myDataTable As SqlDataTable = New SqlDataTable(myCommand, myConnection) 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

Public Sub UseDataTable(ByVal myConnection As SqlConnection)
  Dim myCommand As SqlCommand = New SqlCommand("SELECT * FROM Test.Dept")
  Dim myDataTable As SqlDataTable = New SqlDataTable(myCommand, myConnection)
  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

SqlDataTable Class
SqlDataTable Members
Overload List

Send Feedback