SqlClient.GetRow Method

SqlClient GetRow Method

Nemiro.Data.dll

Executes the query and returns data row. 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 DataRow GetRow()

public DataRow GetRow()

Public Function GetRow As DataRow

Public Function GetRow As DataRow

Return Value

Type: DataRow

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 WHERE login = 'anylogin';";
  DataRow row = c.GetRow();
  if(row != null)
  {
    Console.WriteLine("nickname = {0}", row["nickname"]);
  }
}

using (SqlClient c = new SqlClient())
{
  c.CommandText = "SELECT * FROM users WHERE login = 'anylogin';";
  DataRow row = c.GetRow();
  if(row != null)
  {
    Console.WriteLine("nickname = {0}", row["nickname"]);
  }
}

Using c As new SqlClient()
  c.CommandText = "SELECT * FROM users WHERE login = 'anylogin';" 
  Dim row As DataRow = c.GetRow()
   If row IsNot Nothing Then
    Console.WriteLine("nickname = {0}", row("nickname"))
  End If 
End Using

Using c As new SqlClient()
  c.CommandText = "SELECT * FROM users WHERE login = 'anylogin';" 
  Dim row As DataRow = c.GetRow()
   If row IsNot Nothing Then
    Console.WriteLine("nickname = {0}", row("nickname"))
  End If 
End Using