共用方式為

SqlParameterCollection.AddWithValue(String, Object) 方法

  • 參考

定義

命名空間:
System.Data.SqlClient
組件:
System.Data.SqlClient.dll
組件:
System.Data.dll
套件:
System.Data.SqlClient v4.8.6

將值新增至 SqlParameterCollection結尾。

public:
 System::Data::SqlClient::SqlParameter ^ AddWithValue(System::String ^ parameterName, System::Object ^ value);
public System.Data.SqlClient.SqlParameter AddWithValue (string parameterName, object value);
member this.AddWithValue : string * obj -> System.Data.SqlClient.SqlParameter
Public Function AddWithValue (parameterName As String, value As Object) As SqlParameter

參數

parameterName
String

參數的名稱。

value
Object

要加入的值。 使用 Value 而非 null 來表示 null 值。

傳回

SqlParameter

SqlParameter 物件。

範例

下列範例示範如何使用 AddWithValue 方法。

private static void UpdateDemographics(Int32 customerID,
    string demoXml, string connectionString)
{
    // Update the demographics for a store, which is stored
    // in an xml column.
    string commandText = "UPDATE Sales.Store SET Demographics = @demographics "
        + "WHERE CustomerID = @ID;";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(commandText, connection);
        command.Parameters.Add("@ID", SqlDbType.Int);
        command.Parameters["@ID"].Value = customerID;

        // Use AddWithValue to assign Demographics.
        // SQL Server will implicitly convert strings into XML.
        command.Parameters.AddWithValue("@demographics", demoXml);

        try
        {
            connection.Open();
            Int32 rowsAffected = command.ExecuteNonQuery();
            Console.WriteLine("RowsAffected: {0}", rowsAffected);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
    }
}

Private Sub UpdateDemographics(ByVal customerID As Integer, _
    ByVal demoXml As String, _
    ByVal connectionString As String)

    ' Update the demographics for a store, which is stored 
    ' in an xml column.
    Dim commandText As String = _
     "UPDATE Sales.Store SET Demographics = @demographics " _
     & "WHERE CustomerID = @ID;"

    Using connection As New SqlConnection(connectionString)
        Dim command As New SqlCommand(commandText, connection)

        ' Add CustomerID parameter for WHERE clause.
        command.Parameters.Add("@ID", SqlDbType.Int)
        command.Parameters("@ID").Value = customerID

        ' Use AddWithValue to assign Demographics.
        ' SQL Server will implicitly convert strings into XML.
        command.Parameters.AddWithValue("@demographics", demoXml)

        Try
            connection.Open()
            Dim rowsAffected As Integer = command.ExecuteNonQuery()
            Console.WriteLine("RowsAffected: {0}", rowsAffected)

        Catch ex As Exception
            Console.WriteLine(ex.Message)
        End Try
    End Using
End Sub

備註

AddWithValue 會取代採用 String 和 Object的 SqlParameterCollection.Add 方法。 採用字串和物件的 Add 多載已被取代，因為 SqlParameterCollection.Add 多載可能會模棱兩可，而該多載會採用 String 和 SqlDbType 列舉值，其中傳遞具有字符串的整數可以解譯為參數值或對應的 SqlDbType 值。 每當您想要藉由指定參數名稱和值來新增參數時，請使用 AddWithValue。

針對 SqlDbTypeXml 列舉值，您可以使用字串、XML 值、XmlReader 衍生類型實例或 SqlXml 物件。

適用於

另請參閱