SqlConnection.CreateCommand Méthode

  • Référence

Définition

Espace de noms:
System.Data.SqlClient
Assembly:
System.Data.SqlClient.dll
Assembly:
System.Data.dll
Assemblys:
netstandard.dll, System.Data.SqlClient.dll
Paquet:
System.Data.SqlClient v4.8.6

Crée et retourne un objet SqlCommand associé à SqlConnection.

public:
 System::Data::SqlClient::SqlCommand ^ CreateCommand();
public System.Data.SqlClient.SqlCommand CreateCommand ();
override this.CreateCommand : unit -> System.Data.SqlClient.SqlCommand
member this.CreateCommand : unit -> System.Data.SqlClient.SqlCommand
Public Function CreateCommand () As SqlCommand

Retours

SqlCommand

Objet SqlCommand.

Exemples

using System.Data;
using System.Data.SqlClient;
public class A {
   public static void Main() {
      using (SqlConnection connection = new SqlConnection("Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI;")) {
         connection.Open();
         SqlCommand command= connection.CreateCommand();
         command.CommandText = "SELECT * FROM Categories ORDER BY CategoryID";
         command.CommandTimeout = 15;
         command.CommandType = CommandType.Text;
      }
   }
}

Imports System.Data
Imports System.Data.SqlClient
Public Class A
   Public Shared Sub Main()
      Using connection As New SqlConnection("Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI;")
      connection.Open()
      Dim command As SqlCommand = connection.CreateCommand()
      command.CommandText = "SELECT * FROM Categories ORDER BY CategoryID"
      command.CommandTimeout = 15
      command.CommandType = CommandType.Text
      End Using
   End Sub
End Class

S’applique à

Voir aussi