SqlClient.GetTable Method

SqlClient GetTable Method

Nemiro.Data.dll

Executes the query and returns DataTable. This method is used in conjunction with the properties CommandType, CommandText and Parameters.

Namespace: Nemiro.Data.Sql
Assembly: Nemiro.Data (in Nemiro.Data.dll) Version: 2.11.4.126 (2.11.4.126)

Syntax

C++

Copy to Clipboard Print

public DataTable GetTable()

public DataTable GetTable()

Public Function GetTable As DataTable

Public Function GetTable As DataTable

Return Value

Type: DataTable

Exceptions

Exception	Condition
SqlException	The exception that is thrown when SQL Server returns a warning or error.

Examples

C++

Copy to Clipboard Print

using (SqlClient c = new SqlClient())
{
  c.CommandText = "SELECT * FROM users;";
  DataTable table = c.GetTable();
  foreach(DataRow row in table.Rows)
  {
    Console.WriteLine("login = {0}", row["login"]);
  }
}

using (SqlClient c = new SqlClient())
{
  c.CommandText = "SELECT * FROM users;";
  DataTable table = c.GetTable();
  foreach(DataRow row in table.Rows)
  {
    Console.WriteLine("login = {0}", row["login"]);
  }
}

Using c As new SqlClient()
  c.CommandText = "SELECT * FROM users;" 
  Dim table As DataTable = c.GetTable()
  For Each row As DataRow In table.Rows
    Console.WriteLine("login = {0}", row("login"))
  Next 
End Using

Using c As new SqlClient()
  c.CommandText = "SELECT * FROM users;" 
  Dim table As DataTable = c.GetTable()
  For Each row As DataRow In table.Rows
    Console.WriteLine("login = {0}", row("login"))
  Next 
End Using