SqlClient.CommandText Property

SqlClient CommandText Property

Nemiro.Data.dll

The text of the SQL statements or stored procedure name, you must perform.

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

Syntax

public string CommandText { get; set; }

public string CommandText { get; set; }

Public Property CommandText As String 
	Get 
	Set

Public Property CommandText As String 
	Get 
	Set

Type: String

Examples

using (SqlClient client = new SqlClient())
{
  client.CommandText = "DELETE FROM table WHERE id = 10";
  client.ExecuteNonQuery();
}

using (SqlClient client = new SqlClient())
{
  client.CommandText = "DELETE FROM table WHERE id = 10";
  client.ExecuteNonQuery();
}

Using client As New SqlClient())
  client.CommandText = "DELETE FROM table WHERE id = 10"
  client.ExecuteNonQuery()
End Using

Using client As New SqlClient())
  client.CommandText = "DELETE FROM table WHERE id = 10"
  client.ExecuteNonQuery()
End Using