how to take user input in pl/sql of sql server 2005

// Update the name of a customer, which is passed by user
// customerID passed by you to DB as integer value
// inputCustomerName passed by you to DB as string value
string commandText = "UPDATE Store SET CustomerName = @custName 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 customer name.
        command.Parameters.AddWithValue("@custName", inputCustomerName);

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