dotConnect for SQL Server Documentation
Devart.Data.SqlServer Namespace / SqlCommand Class / CreateParameter Method
Example

In This Topic
    CreateParameter Method (SqlCommand)
    In This Topic
    Creates a new instance of a SqlParameter object.
    Creates a new instance of a SqlParameter object.
    Syntax
    'Declaration
     
    Public Shadows Function CreateParameter() As SqlParameter
    public new SqlParameter CreateParameter()

    Return Value

    A SqlParameter object.
    Remarks
    This method is a strongly-typed version of System.Data.IDbCommand.CreateParameter. See SqlParameter to find out more ways to create a parameter.
    Example
    This sample shows how to create a parameter using CreateParameter function.
    Public void CreateParam(SqlConnection myConnection)
    {
      SqlCommand myCommand = new SqlCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno",myConnection);
      SqlParameter myParam = myCommand.CreateParameter();
      myParam.SqlType = Devart.Data.SqlServer.SqlType.Int;
      myParam.Value = 10;
      myParam.ParameterName = "Deptno";
      myCommand.Parameters.Add(myParam);
      myConnection.Open();
      SqlDataReader myReader = null; 
      try
      {
        myReader = myCommand.ExecuteReader(); 
        while (myReader.Read())
        {
          Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1) + ", " + myReader.GetString(2));
        }
      }
      finally
      {
        myReader.Close();
        myConnection.Close();
      }
    }
    Public Sub CreateParam(ByVal myConnection As SqlConnection)
      Dim myCommand As New SqlCommand("SELECT * FROM Test.Dept WHERE DeptNo=:Deptno", myConnection)
      Dim myParam As SqlParameter = myCommand.CreateParameter()
      myParam.SqlType = Devart.Data.SqlServer.SqlType.Int
      myParam.Value = 10
      myParam.ParameterName = "Deptno"
      myCommand.Parameters.Add(myParam)
      myConnection.Open()
      Dim myReader As SqlDataReader = Nothing
      Try
        myReader = myCommand.ExecuteReader()
        While myReader.Read()
          Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _
            + myReader.GetString(1) + ", " _
            + myReader.GetString(2))
        End While
      Finally
        myReader.Close()
        myConnection.Close()
      End Try
    End Sub
    See Also